Dataset statistics
| Number of variables | 47 |
|---|---|
| Number of observations | 60398 |
| Missing cells | 1 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 21.7 MiB |
| Average record size in memory | 376.0 B |
Variable types
| Numeric | 18 |
|---|---|
| Categorical | 21 |
| Text | 3 |
| DateTime | 5 |
RevisionNumber has constant value "" | Constant |
OrderQuantity has constant value "" | Constant |
Age is highly overall correlated with Age Range and 1 other fields | High correlation |
Age Range is highly overall correlated with Age | High correlation |
Cost is highly overall correlated with DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName and 9 other fields | High correlation |
CurrencyKey is highly overall correlated with DimCurrency.CurrencyName and 4 other fields | High correlation |
DimCurrency.CurrencyName is highly overall correlated with CurrencyKey and 3 other fields | High correlation |
DimCustomer.EnglishOccupation is highly overall correlated with YearlyIncomeRange | High correlation |
DimCustomer.TotalChildren is highly overall correlated with Age | High correlation |
DimCustomer.YearlyIncome is highly overall correlated with YearlyIncomeRange | High correlation |
DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName is highly overall correlated with Cost and 9 other fields | High correlation |
DimProduct.DimProductSubcategory.EnglishProductSubcategoryName is highly overall correlated with DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName and 1 other fields | High correlation |
DimProduct.ProductSubcategoryKey is highly overall correlated with Cost and 9 other fields | High correlation |
DimPromotion.EnglishPromotionCategory is highly overall correlated with DimPromotion.EnglishPromotionName and 2 other fields | High correlation |
DimPromotion.EnglishPromotionName is highly overall correlated with DimPromotion.EnglishPromotionCategory and 2 other fields | High correlation |
DimPromotion.EnglishPromotionType is highly overall correlated with DimPromotion.EnglishPromotionCategory and 2 other fields | High correlation |
DimSalesTerritory.SalesTerritoryCountry is highly overall correlated with CurrencyKey and 4 other fields | High correlation |
DimSalesTerritory.SalesTerritoryGroup is highly overall correlated with CurrencyKey and 3 other fields | High correlation |
DimSalesTerritory.SalesTerritoryRegion is highly overall correlated with CurrencyKey and 3 other fields | High correlation |
ExtendedAmount is highly overall correlated with Cost and 9 other fields | High correlation |
Freight is highly overall correlated with Cost and 9 other fields | High correlation |
ProductKey is highly overall correlated with DimProduct.DimProductSubcategory.EnglishProductSubcategoryName | High correlation |
ProductStandardCost is highly overall correlated with Cost and 9 other fields | High correlation |
Profit is highly overall correlated with Cost and 8 other fields | High correlation |
PromotionKey is highly overall correlated with DimPromotion.EnglishPromotionCategory and 2 other fields | High correlation |
SalesAmount is highly overall correlated with Cost and 9 other fields | High correlation |
SalesTerritoryKey is highly overall correlated with CurrencyKey and 1 other fields | High correlation |
TaxAmt is highly overall correlated with Cost and 9 other fields | High correlation |
TotalProductCost is highly overall correlated with Cost and 9 other fields | High correlation |
UnitPrice is highly overall correlated with Cost and 9 other fields | High correlation |
YearlyIncomeRange is highly overall correlated with DimCustomer.EnglishOccupation and 1 other fields | High correlation |
PromotionKey is highly imbalanced (88.7%) | Imbalance |
DimPromotion.EnglishPromotionName is highly imbalanced (88.7%) | Imbalance |
DimPromotion.EnglishPromotionType is highly imbalanced (85.7%) | Imbalance |
DimPromotion.EnglishPromotionCategory is highly imbalanced (77.8%) | Imbalance |
DimCustomer.TotalChildren has 17048 (28.2%) zeros | Zeros |
Reproduction
| Analysis started | 2024-04-07 17:14:08.762962 |
|---|---|
| Analysis finished | 2024-04-07 17:16:38.715919 |
| Duration | 2 minutes and 29.95 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
ProductKey
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 158 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 437.55793 |
| Minimum | 214 |
|---|---|
| Maximum | 606 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 214 |
|---|---|
| 5-th percentile | 217 |
| Q1 | 359 |
| median | 479 |
| Q3 | 529 |
| 95-th percentile | 581 |
| Maximum | 606 |
| Range | 392 |
| Interquartile range (IQR) | 170 |
Descriptive statistics
| Standard deviation | 118.08839 |
|---|---|
| Coefficient of variation (CV) | 0.26988058 |
| Kurtosis | -0.67398995 |
| Mean | 437.55793 |
| Median Absolute Deviation (MAD) | 58 |
| Skewness | -0.79879556 |
| Sum | 26427624 |
| Variance | 13944.868 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 477 | 4244 | 7.0% |
| 480 | 3191 | 5.3% |
| 528 | 3095 | 5.1% |
| 529 | 2376 | 3.9% |
| 214 | 2230 | 3.7% |
| 225 | 2190 | 3.6% |
| 222 | 2125 | 3.5% |
| 485 | 2121 | 3.5% |
| 217 | 2085 | 3.5% |
| 478 | 2025 | 3.4% |
| Other values (148) | 34716 |
| Value | Count | Frequency (%) |
| 214 | 2230 | |
| 217 | 2085 | |
| 222 | 2125 | |
| 225 | 2190 | |
| 228 | 429 | 0.7% |
| 231 | 442 | 0.7% |
| 234 | 452 | 0.7% |
| 237 | 413 | 0.7% |
| 310 | 336 | 0.6% |
| 311 | 281 | 0.5% |
| Value | Count | Frequency (%) |
| 606 | 386 | |
| 605 | 363 | |
| 604 | 360 | |
| 600 | 41 | 0.1% |
| 599 | 56 | 0.1% |
| 598 | 58 | 0.1% |
| 597 | 49 | 0.1% |
| 596 | 48 | 0.1% |
| 595 | 48 | 0.1% |
| 594 | 50 | 0.1% |
CustomerKey
Real number (ℝ)
| Distinct | 18484 |
|---|---|
| Distinct (%) | 30.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18841.685 |
| Minimum | 11000 |
|---|---|
| Maximum | 29483 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 11000 |
|---|---|
| 5-th percentile | 11414 |
| Q1 | 14003 |
| median | 18143 |
| Q3 | 23429.75 |
| 95-th percentile | 28108.15 |
| Maximum | 29483 |
| Range | 18483 |
| Interquartile range (IQR) | 9426.75 |
Descriptive statistics
| Standard deviation | 5432.4304 |
|---|---|
| Coefficient of variation (CV) | 0.28831977 |
| Kurtosis | -1.1617483 |
| Mean | 18841.685 |
| Median Absolute Deviation (MAD) | 4594.5 |
| Skewness | 0.28365312 |
| Sum | 1.1380001 × 109 |
| Variance | 29511300 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11185 | 68 | 0.1% |
| 11300 | 67 | 0.1% |
| 11277 | 65 | 0.1% |
| 11262 | 63 | 0.1% |
| 11287 | 62 | 0.1% |
| 11176 | 60 | 0.1% |
| 11091 | 59 | 0.1% |
| 11331 | 58 | 0.1% |
| 11566 | 58 | 0.1% |
| 11330 | 57 | 0.1% |
| Other values (18474) | 59781 |
| Value | Count | Frequency (%) |
| 11000 | 8 | |
| 11001 | 11 | |
| 11002 | 4 | < 0.1% |
| 11003 | 9 | |
| 11004 | 6 | |
| 11005 | 6 | |
| 11006 | 5 | |
| 11007 | 8 | |
| 11008 | 7 | |
| 11009 | 5 |
| Value | Count | Frequency (%) |
| 29483 | 1 | < 0.1% |
| 29482 | 1 | < 0.1% |
| 29481 | 1 | < 0.1% |
| 29480 | 5 | |
| 29479 | 1 | < 0.1% |
| 29478 | 3 | |
| 29477 | 3 | |
| 29476 | 1 | < 0.1% |
| 29475 | 1 | < 0.1% |
| 29474 | 1 | < 0.1% |
PromotionKey
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| 1 | |
|---|---|
| 2 | 2118 |
| 13 | 20 |
| 14 | 13 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.0005464 |
| Min length | 1 |
Characters and Unicode
| Total characters | 60431 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 58247 | |
| 2 | 2118 | 3.5% |
| 13 | 20 | < 0.1% |
| 14 | 13 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 58247 | |
| 2 | 2118 | 3.5% |
| 13 | 20 | < 0.1% |
| 14 | 13 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 58280 | |
| 2 | 2118 | 3.5% |
| 3 | 20 | < 0.1% |
| 4 | 13 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 60431 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 58280 | |
| 2 | 2118 | 3.5% |
| 3 | 20 | < 0.1% |
| 4 | 13 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 60431 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 58280 | |
| 2 | 2118 | 3.5% |
| 3 | 20 | < 0.1% |
| 4 | 13 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 60431 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 58280 | |
| 2 | 2118 | 3.5% |
| 3 | 20 | < 0.1% |
| 4 | 13 | < 0.1% |
CurrencyKey
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.845326 |
| Minimum | 6 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 19 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 94 |
| Interquartile range (IQR) | 81 |
Descriptive statistics
| Standard deviation | 42.146363 |
|---|---|
| Coefficient of variation (CV) | 0.60342425 |
| Kurtosis | -1.4488281 |
| Mean | 69.845326 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.72070268 |
| Sum | 4218518 |
| Variance | 1776.3159 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 33400 | |
| 6 | 12988 | 21.5% |
| 19 | 7135 | 11.8% |
| 98 | 6740 | 11.2% |
| 29 | 76 | 0.1% |
| 39 | 59 | 0.1% |
| Value | Count | Frequency (%) |
| 6 | 12988 | 21.5% |
| 19 | 7135 | 11.8% |
| 29 | 76 | 0.1% |
| 39 | 59 | 0.1% |
| 98 | 6740 | 11.2% |
| 100 | 33400 |
| Value | Count | Frequency (%) |
| 100 | 33400 | |
| 98 | 6740 | 11.2% |
| 39 | 59 | 0.1% |
| 29 | 76 | 0.1% |
| 19 | 7135 | 11.8% |
| 6 | 12988 | 21.5% |
SalesTerritoryKey
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.2444617 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.9611497 |
|---|---|
| Coefficient of variation (CV) | 0.47420416 |
| Kurtosis | -0.99206078 |
| Mean | 6.2444617 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.48527069 |
| Sum | 377153 |
| Variance | 8.7684077 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 13345 | |
| 4 | 12265 | |
| 1 | 8993 | |
| 6 | 7620 | |
| 10 | 6906 | |
| 8 | 5625 | |
| 7 | 5558 | |
| 5 | 39 | 0.1% |
| 2 | 27 | < 0.1% |
| 3 | 20 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 8993 | |
| 2 | 27 | < 0.1% |
| 3 | 20 | < 0.1% |
| 4 | 12265 | |
| 5 | 39 | 0.1% |
| 6 | 7620 | |
| 7 | 5558 | |
| 8 | 5625 | |
| 9 | 13345 | |
| 10 | 6906 |
| Value | Count | Frequency (%) |
| 10 | 6906 | |
| 9 | 13345 | |
| 8 | 5625 | |
| 7 | 5558 | |
| 6 | 7620 | |
| 5 | 39 | 0.1% |
| 4 | 12265 | |
| 3 | 20 | < 0.1% |
| 2 | 27 | < 0.1% |
| 1 | 8993 |
SalesOrderNumber
Text
| Distinct | 27659 |
|---|---|
| Distinct (%) | 45.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 422786 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 9668 ? |
|---|---|
| Unique (%) | 16.0% |
Sample
| 1st row | SO43700 |
|---|---|
| 2nd row | SO43719 |
| 3rd row | SO43726 |
| 4th row | SO43762 |
| 5th row | SO43771 |
| Value | Count | Frequency (%) |
| so72656 | 8 | < 0.1% |
| so58845 | 8 | < 0.1% |
| so70714 | 8 | < 0.1% |
| so58572 | 7 | < 0.1% |
| so74869 | 7 | < 0.1% |
| so71961 | 7 | < 0.1% |
| so51555 | 7 | < 0.1% |
| so61412 | 7 | < 0.1% |
| so54784 | 7 | < 0.1% |
| so64542 | 7 | < 0.1% |
| Other values (27649) | 60325 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 60398 | |
| O | 60398 | |
| 6 | 47143 | |
| 5 | 44004 | |
| 7 | 35344 | |
| 4 | 30836 | |
| 2 | 25066 | |
| 3 | 24928 | |
| 1 | 23946 | 5.7% |
| 0 | 23824 | 5.6% |
| Other values (2) | 46899 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 422786 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 60398 | |
| O | 60398 | |
| 6 | 47143 | |
| 5 | 44004 | |
| 7 | 35344 | |
| 4 | 30836 | |
| 2 | 25066 | |
| 3 | 24928 | |
| 1 | 23946 | 5.7% |
| 0 | 23824 | 5.6% |
| Other values (2) | 46899 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 422786 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 60398 | |
| O | 60398 | |
| 6 | 47143 | |
| 5 | 44004 | |
| 7 | 35344 | |
| 4 | 30836 | |
| 2 | 25066 | |
| 3 | 24928 | |
| 1 | 23946 | 5.7% |
| 0 | 23824 | 5.6% |
| Other values (2) | 46899 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 422786 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 60398 | |
| O | 60398 | |
| 6 | 47143 | |
| 5 | 44004 | |
| 7 | 35344 | |
| 4 | 30836 | |
| 2 | 25066 | |
| 3 | 24928 | |
| 1 | 23946 | 5.7% |
| 0 | 23824 | 5.6% |
| Other values (2) | 46899 |
SalesOrderLineNumber
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8863207 |
| Minimum | 1 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.0163284 |
|---|---|
| Coefficient of variation (CV) | 0.53878876 |
| Kurtosis | 0.69706876 |
| Mean | 1.8863207 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.0693116 |
| Sum | 113930 |
| Variance | 1.0329235 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 27659 | |
| 2 | 17991 | |
| 3 | 9828 | 16.3% |
| 4 | 3958 | 6.6% |
| 5 | 820 | 1.4% |
| 6 | 124 | 0.2% |
| 7 | 15 | < 0.1% |
| 8 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 27659 | |
| 2 | 17991 | |
| 3 | 9828 | 16.3% |
| 4 | 3958 | 6.6% |
| 5 | 820 | 1.4% |
| 6 | 124 | 0.2% |
| 7 | 15 | < 0.1% |
| 8 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 8 | 3 | < 0.1% |
| 7 | 15 | < 0.1% |
| 6 | 124 | 0.2% |
| 5 | 820 | 1.4% |
| 4 | 3958 | 6.6% |
| 3 | 9828 | 16.3% |
| 2 | 17991 | |
| 1 | 27659 |
RevisionNumber
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 60398 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 60398 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 60398 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 60398 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 60398 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 60398 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 60398 |
OrderQuantity
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 60398 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 60398 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 60398 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 60398 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 60398 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 60398 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 60398 |
UnitPrice
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 42 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 486.08691 |
| Minimum | 2.29 |
|---|---|
| Maximum | 3578.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 2.29 |
|---|---|
| 5-th percentile | 2.29 |
| Q1 | 7.95 |
| median | 29.99 |
| Q3 | 539.99 |
| 95-th percentile | 2443.35 |
| Maximum | 3578.27 |
| Range | 3575.98 |
| Interquartile range (IQR) | 532.04 |
Descriptive statistics
| Standard deviation | 928.48989 |
|---|---|
| Coefficient of variation (CV) | 1.9101314 |
| Kurtosis | 2.5136486 |
| Mean | 486.08691 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 1.9275149 |
| Sum | 29358677 |
| Variance | 862093.48 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.99 | 8827 | 14.6% |
| 34.99 | 6440 | 10.7% |
| 8.99 | 4470 | 7.4% |
| 2.29 | 3191 | 5.3% |
| 3.99 | 2376 | 3.9% |
| 21.98 | 2121 | 3.5% |
| 9.99 | 2025 | 3.4% |
| 24.99 | 1788 | 3.0% |
| 49.99 | 1736 | 2.9% |
| 539.99 | 1695 | 2.8% |
| Other values (32) | 25729 |
| Value | Count | Frequency (%) |
| 2.29 | 3191 | 5.3% |
| 3.99 | 2376 | 3.9% |
| 4.99 | 8827 | |
| 7.95 | 908 | 1.5% |
| 8.99 | 4470 | |
| 9.99 | 2025 | 3.4% |
| 21.49 | 1044 | 1.7% |
| 21.98 | 2121 | 3.5% |
| 24.49 | 1430 | 2.4% |
| 24.99 | 1788 | 3.0% |
| Value | Count | Frequency (%) |
| 3578.27 | 1551 | |
| 3399.99 | 185 | 0.3% |
| 3374.99 | 211 | 0.3% |
| 2443.35 | 1145 | |
| 2384.07 | 1255 | |
| 2319.99 | 1215 | |
| 2294.99 | 1262 | |
| 2181.5625 | 758 | |
| 2071.4196 | 521 | 0.9% |
| 2049.0982 | 554 | 0.9% |
ExtendedAmount
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 42 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 486.08691 |
| Minimum | 2.29 |
|---|---|
| Maximum | 3578.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 2.29 |
|---|---|
| 5-th percentile | 2.29 |
| Q1 | 7.95 |
| median | 29.99 |
| Q3 | 539.99 |
| 95-th percentile | 2443.35 |
| Maximum | 3578.27 |
| Range | 3575.98 |
| Interquartile range (IQR) | 532.04 |
Descriptive statistics
| Standard deviation | 928.48989 |
|---|---|
| Coefficient of variation (CV) | 1.9101314 |
| Kurtosis | 2.5136486 |
| Mean | 486.08691 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 1.9275149 |
| Sum | 29358677 |
| Variance | 862093.48 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.99 | 8827 | 14.6% |
| 34.99 | 6440 | 10.7% |
| 8.99 | 4470 | 7.4% |
| 2.29 | 3191 | 5.3% |
| 3.99 | 2376 | 3.9% |
| 21.98 | 2121 | 3.5% |
| 9.99 | 2025 | 3.4% |
| 24.99 | 1788 | 3.0% |
| 49.99 | 1736 | 2.9% |
| 539.99 | 1695 | 2.8% |
| Other values (32) | 25729 |
| Value | Count | Frequency (%) |
| 2.29 | 3191 | 5.3% |
| 3.99 | 2376 | 3.9% |
| 4.99 | 8827 | |
| 7.95 | 908 | 1.5% |
| 8.99 | 4470 | |
| 9.99 | 2025 | 3.4% |
| 21.49 | 1044 | 1.7% |
| 21.98 | 2121 | 3.5% |
| 24.49 | 1430 | 2.4% |
| 24.99 | 1788 | 3.0% |
| Value | Count | Frequency (%) |
| 3578.27 | 1551 | |
| 3399.99 | 185 | 0.3% |
| 3374.99 | 211 | 0.3% |
| 2443.35 | 1145 | |
| 2384.07 | 1255 | |
| 2319.99 | 1215 | |
| 2294.99 | 1262 | |
| 2181.5625 | 758 | |
| 2071.4196 | 521 | 0.9% |
| 2049.0982 | 554 | 0.9% |
ProductStandardCost
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 286.06566 |
| Minimum | 0.8565 |
|---|---|
| Maximum | 2171.2942 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 0.8565 |
|---|---|
| 5-th percentile | 0.8565 |
| Q1 | 2.9733 |
| median | 11.2163 |
| Q3 | 294.5797 |
| 95-th percentile | 1518.7864 |
| Maximum | 2171.2942 |
| Range | 2170.4377 |
| Interquartile range (IQR) | 291.6064 |
Descriptive statistics
| Standard deviation | 552.45764 |
|---|---|
| Coefficient of variation (CV) | 1.9312267 |
| Kurtosis | 2.6883605 |
| Mean | 286.06566 |
| Median Absolute Deviation (MAD) | 9.35 |
| Skewness | 1.9505468 |
| Sum | 17277794 |
| Variance | 305209.44 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.8663 | 8827 | 14.6% |
| 13.0863 | 6440 | 10.7% |
| 0.8565 | 3191 | 5.3% |
| 1.4923 | 2376 | 3.9% |
| 3.3623 | 2280 | 3.8% |
| 6.9223 | 2190 | 3.6% |
| 8.2205 | 2121 | 3.5% |
| 3.7363 | 2025 | 3.4% |
| 9.3463 | 1788 | 3.0% |
| 38.4923 | 1736 | 2.9% |
| Other values (35) | 27424 |
| Value | Count | Frequency (%) |
| 0.8565 | 3191 | 5.3% |
| 1.4923 | 2376 | 3.9% |
| 1.8663 | 8827 | |
| 2.9733 | 908 | 1.5% |
| 3.3623 | 2280 | 3.8% |
| 3.7363 | 2025 | 3.4% |
| 6.9223 | 2190 | 3.6% |
| 8.0373 | 1044 | 1.7% |
| 8.2205 | 2121 | 3.5% |
| 9.1593 | 1430 | 2.4% |
| Value | Count | Frequency (%) |
| 2171.2942 | 1551 | |
| 1912.1544 | 185 | 0.3% |
| 1898.0944 | 211 | 0.3% |
| 1554.9479 | 706 | |
| 1518.7864 | 439 | 0.7% |
| 1481.9379 | 1255 | |
| 1320.6838 | 758 | |
| 1265.6195 | 1215 | |
| 1251.9813 | 1262 | |
| 1117.8559 | 521 | 0.9% |
TotalProductCost
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 286.06566 |
| Minimum | 0.8565 |
|---|---|
| Maximum | 2171.2942 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 0.8565 |
|---|---|
| 5-th percentile | 0.8565 |
| Q1 | 2.9733 |
| median | 11.2163 |
| Q3 | 294.5797 |
| 95-th percentile | 1518.7864 |
| Maximum | 2171.2942 |
| Range | 2170.4377 |
| Interquartile range (IQR) | 291.6064 |
Descriptive statistics
| Standard deviation | 552.45764 |
|---|---|
| Coefficient of variation (CV) | 1.9312267 |
| Kurtosis | 2.6883605 |
| Mean | 286.06566 |
| Median Absolute Deviation (MAD) | 9.35 |
| Skewness | 1.9505468 |
| Sum | 17277794 |
| Variance | 305209.44 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.8663 | 8827 | 14.6% |
| 13.0863 | 6440 | 10.7% |
| 0.8565 | 3191 | 5.3% |
| 1.4923 | 2376 | 3.9% |
| 3.3623 | 2280 | 3.8% |
| 6.9223 | 2190 | 3.6% |
| 8.2205 | 2121 | 3.5% |
| 3.7363 | 2025 | 3.4% |
| 9.3463 | 1788 | 3.0% |
| 38.4923 | 1736 | 2.9% |
| Other values (35) | 27424 |
| Value | Count | Frequency (%) |
| 0.8565 | 3191 | 5.3% |
| 1.4923 | 2376 | 3.9% |
| 1.8663 | 8827 | |
| 2.9733 | 908 | 1.5% |
| 3.3623 | 2280 | 3.8% |
| 3.7363 | 2025 | 3.4% |
| 6.9223 | 2190 | 3.6% |
| 8.0373 | 1044 | 1.7% |
| 8.2205 | 2121 | 3.5% |
| 9.1593 | 1430 | 2.4% |
| Value | Count | Frequency (%) |
| 2171.2942 | 1551 | |
| 1912.1544 | 185 | 0.3% |
| 1898.0944 | 211 | 0.3% |
| 1554.9479 | 706 | |
| 1518.7864 | 439 | 0.7% |
| 1481.9379 | 1255 | |
| 1320.6838 | 758 | |
| 1265.6195 | 1215 | |
| 1251.9813 | 1262 | |
| 1117.8559 | 521 | 0.9% |
SalesAmount
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 42 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 486.08691 |
| Minimum | 2.29 |
|---|---|
| Maximum | 3578.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 2.29 |
|---|---|
| 5-th percentile | 2.29 |
| Q1 | 7.95 |
| median | 29.99 |
| Q3 | 539.99 |
| 95-th percentile | 2443.35 |
| Maximum | 3578.27 |
| Range | 3575.98 |
| Interquartile range (IQR) | 532.04 |
Descriptive statistics
| Standard deviation | 928.48989 |
|---|---|
| Coefficient of variation (CV) | 1.9101314 |
| Kurtosis | 2.5136486 |
| Mean | 486.08691 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 1.9275149 |
| Sum | 29358677 |
| Variance | 862093.48 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.99 | 8827 | 14.6% |
| 34.99 | 6440 | 10.7% |
| 8.99 | 4470 | 7.4% |
| 2.29 | 3191 | 5.3% |
| 3.99 | 2376 | 3.9% |
| 21.98 | 2121 | 3.5% |
| 9.99 | 2025 | 3.4% |
| 24.99 | 1788 | 3.0% |
| 49.99 | 1736 | 2.9% |
| 539.99 | 1695 | 2.8% |
| Other values (32) | 25729 |
| Value | Count | Frequency (%) |
| 2.29 | 3191 | 5.3% |
| 3.99 | 2376 | 3.9% |
| 4.99 | 8827 | |
| 7.95 | 908 | 1.5% |
| 8.99 | 4470 | |
| 9.99 | 2025 | 3.4% |
| 21.49 | 1044 | 1.7% |
| 21.98 | 2121 | 3.5% |
| 24.49 | 1430 | 2.4% |
| 24.99 | 1788 | 3.0% |
| Value | Count | Frequency (%) |
| 3578.27 | 1551 | |
| 3399.99 | 185 | 0.3% |
| 3374.99 | 211 | 0.3% |
| 2443.35 | 1145 | |
| 2384.07 | 1255 | |
| 2319.99 | 1215 | |
| 2294.99 | 1262 | |
| 2181.5625 | 758 | |
| 2071.4196 | 521 | 0.9% |
| 2049.0982 | 554 | 0.9% |
TaxAmt
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 42 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.886954 |
| Minimum | 0.1832 |
|---|---|
| Maximum | 286.2616 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 0.1832 |
|---|---|
| 5-th percentile | 0.1832 |
| Q1 | 0.636 |
| median | 2.3992 |
| Q3 | 43.1992 |
| 95-th percentile | 195.468 |
| Maximum | 286.2616 |
| Range | 286.0784 |
| Interquartile range (IQR) | 42.5632 |
Descriptive statistics
| Standard deviation | 74.279193 |
|---|---|
| Coefficient of variation (CV) | 1.9101314 |
| Kurtosis | 2.5136484 |
| Mean | 38.886954 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.9275149 |
| Sum | 2348694.2 |
| Variance | 5517.3984 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.3992 | 8827 | 14.6% |
| 2.7992 | 6440 | 10.7% |
| 0.7192 | 4470 | 7.4% |
| 0.1832 | 3191 | 5.3% |
| 0.3192 | 2376 | 3.9% |
| 1.7584 | 2121 | 3.5% |
| 0.7992 | 2025 | 3.4% |
| 1.9992 | 1788 | 3.0% |
| 3.9992 | 1736 | 2.9% |
| 43.1992 | 1695 | 2.8% |
| Other values (32) | 25729 |
| Value | Count | Frequency (%) |
| 0.1832 | 3191 | 5.3% |
| 0.3192 | 2376 | 3.9% |
| 0.3992 | 8827 | |
| 0.636 | 908 | 1.5% |
| 0.7192 | 4470 | |
| 0.7992 | 2025 | 3.4% |
| 1.7192 | 1044 | 1.7% |
| 1.7584 | 2121 | 3.5% |
| 1.9592 | 1430 | 2.4% |
| 1.9992 | 1788 | 3.0% |
| Value | Count | Frequency (%) |
| 286.2616 | 1551 | |
| 271.9992 | 185 | 0.3% |
| 269.9992 | 211 | 0.3% |
| 195.468 | 1145 | |
| 190.7256 | 1255 | |
| 185.5992 | 1215 | |
| 183.5992 | 1262 | |
| 174.525 | 758 | |
| 165.7136 | 521 | 0.9% |
| 163.9279 | 554 | 0.9% |
Freight
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 42 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.152217 |
| Minimum | 0.0573 |
|---|---|
| Maximum | 89.4568 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 0.0573 |
|---|---|
| 5-th percentile | 0.0573 |
| Q1 | 0.1988 |
| median | 0.7498 |
| Q3 | 13.4998 |
| 95-th percentile | 61.0838 |
| Maximum | 89.4568 |
| Range | 89.3995 |
| Interquartile range (IQR) | 13.301 |
Descriptive statistics
| Standard deviation | 23.212248 |
|---|---|
| Coefficient of variation (CV) | 1.9101245 |
| Kurtosis | 2.5136492 |
| Mean | 12.152217 |
| Median Absolute Deviation (MAD) | 0.625 |
| Skewness | 1.927515 |
| Sum | 733969.61 |
| Variance | 538.80847 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.1248 | 8827 | 14.6% |
| 0.8748 | 6440 | 10.7% |
| 0.2248 | 4470 | 7.4% |
| 0.0573 | 3191 | 5.3% |
| 0.0998 | 2376 | 3.9% |
| 0.5495 | 2121 | 3.5% |
| 0.2498 | 2025 | 3.4% |
| 0.6248 | 1788 | 3.0% |
| 1.2498 | 1736 | 2.9% |
| 13.4998 | 1695 | 2.8% |
| Other values (32) | 25729 |
| Value | Count | Frequency (%) |
| 0.0573 | 3191 | 5.3% |
| 0.0998 | 2376 | 3.9% |
| 0.1248 | 8827 | |
| 0.1988 | 908 | 1.5% |
| 0.2248 | 4470 | |
| 0.2498 | 2025 | 3.4% |
| 0.5373 | 1044 | 1.7% |
| 0.5495 | 2121 | 3.5% |
| 0.6123 | 1430 | 2.4% |
| 0.6248 | 1788 | 3.0% |
| Value | Count | Frequency (%) |
| 89.4568 | 1551 | |
| 84.9998 | 185 | 0.3% |
| 84.3748 | 211 | 0.3% |
| 61.0838 | 1145 | |
| 59.6018 | 1255 | |
| 57.9998 | 1215 | |
| 57.3748 | 1262 | |
| 54.5391 | 758 | |
| 51.7855 | 521 | 0.9% |
| 51.2275 | 554 | 0.9% |
OrderDate
Date
| Distinct | 1124 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Minimum | 2010-12-29 00:00:00 |
|---|---|
| Maximum | 2014-01-28 00:00:00 |
DueDate
Date
| Distinct | 1124 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Minimum | 2011-01-10 00:00:00 |
|---|---|
| Maximum | 2014-02-09 00:00:00 |
ShipDate
Date
| Distinct | 1124 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Minimum | 2011-01-05 00:00:00 |
|---|---|
| Maximum | 2014-02-04 00:00:00 |
DimCurrency.CurrencyName
Categorical
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| US Dollar | |
|---|---|
| Australian Dollar | |
| Canadian Dollar | |
| United Kingdom Pound | |
| Deutsche Mark | 76 |
Length
| Max length | 20 |
|---|---|
| Median length | 9 |
| Mean length | 12.664608 |
| Min length | 9 |
Characters and Unicode
| Total characters | 764917 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | US Dollar |
|---|---|
| 2nd row | US Dollar |
| 3rd row | US Dollar |
| 4th row | US Dollar |
| 5th row | US Dollar |
Common Values
| Value | Count | Frequency (%) |
| US Dollar | 33400 | |
| Australian Dollar | 12988 | 21.5% |
| Canadian Dollar | 7135 | 11.8% |
| United Kingdom Pound | 6740 | 11.2% |
| Deutsche Mark | 76 | 0.1% |
| French Franc | 59 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| dollar | 53523 | |
| us | 33400 | |
| australian | 12988 | 10.2% |
| canadian | 7135 | 5.6% |
| united | 6740 | 5.3% |
| kingdom | 6740 | 5.3% |
| pound | 6740 | 5.3% |
| deutsche | 76 | 0.1% |
| mark | 76 | 0.1% |
| french | 59 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 120034 | |
| a | 101039 | |
| 67138 | ||
| o | 67003 | |
| r | 66705 | |
| D | 53599 | 7.0% |
| n | 47596 | 6.2% |
| U | 40140 | 5.2% |
| i | 33603 | 4.4% |
| S | 33400 | 4.4% |
| Other values (16) | 134660 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 764917 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 120034 | |
| a | 101039 | |
| 67138 | ||
| o | 67003 | |
| r | 66705 | |
| D | 53599 | 7.0% |
| n | 47596 | 6.2% |
| U | 40140 | 5.2% |
| i | 33603 | 4.4% |
| S | 33400 | 4.4% |
| Other values (16) | 134660 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 764917 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 120034 | |
| a | 101039 | |
| 67138 | ||
| o | 67003 | |
| r | 66705 | |
| D | 53599 | 7.0% |
| n | 47596 | 6.2% |
| U | 40140 | 5.2% |
| i | 33603 | 4.4% |
| S | 33400 | 4.4% |
| Other values (16) | 134660 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 764917 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 120034 | |
| a | 101039 | |
| 67138 | ||
| o | 67003 | |
| r | 66705 | |
| D | 53599 | 7.0% |
| n | 47596 | 6.2% |
| U | 40140 | 5.2% |
| i | 33603 | 4.4% |
| S | 33400 | 4.4% |
| Other values (16) | 134660 |
CustomerFullName
Text
| Distinct | 34939 |
|---|---|
| Distinct (%) | 57.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 472.0 KiB |
Length
| Max length | 27 |
|---|---|
| Median length | 23 |
| Mean length | 14.078183 |
| Min length | 7 |
Characters and Unicode
| Total characters | 850280 |
|---|---|
| Distinct characters | 62 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 22715 ? |
|---|---|
| Unique (%) | 37.6% |
Sample
| 1st row | Lucas Hill |
|---|---|
| 2nd row | Kelvin Huang |
| 3rd row | Courtney Carter |
| 4th row | Ashley Washington |
| 5th row | Jeremy Murphy |
| Value | Count | Frequency (%) |
| l | 4215 | 2.7% |
| a | 4168 | 2.7% |
| m | 3785 | 2.4% |
| j | 3166 | 2.0% |
| c | 3067 | 2.0% |
| e | 2303 | 1.5% |
| r | 2186 | 1.4% |
| d | 1964 | 1.3% |
| s | 1585 | 1.0% |
| k | 1114 | 0.7% |
| Other values (1032) | 128153 |
Most occurring characters
| Value | Count | Frequency (%) |
| 120803 | ||
| a | 82885 | 9.7% |
| e | 69538 | 8.2% |
| n | 60164 | 7.1% |
| r | 53992 | 6.3% |
| i | 43499 | 5.1% |
| o | 39828 | 4.7% |
| l | 36502 | 4.3% |
| s | 27912 | 3.3% |
| t | 21626 | 2.5% |
| Other values (52) | 293531 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 850280 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 120803 | ||
| a | 82885 | 9.7% |
| e | 69538 | 8.2% |
| n | 60164 | 7.1% |
| r | 53992 | 6.3% |
| i | 43499 | 5.1% |
| o | 39828 | 4.7% |
| l | 36502 | 4.3% |
| s | 27912 | 3.3% |
| t | 21626 | 2.5% |
| Other values (52) | 293531 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 850280 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 120803 | ||
| a | 82885 | 9.7% |
| e | 69538 | 8.2% |
| n | 60164 | 7.1% |
| r | 53992 | 6.3% |
| i | 43499 | 5.1% |
| o | 39828 | 4.7% |
| l | 36502 | 4.3% |
| s | 27912 | 3.3% |
| t | 21626 | 2.5% |
| Other values (52) | 293531 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 850280 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 120803 | ||
| a | 82885 | 9.7% |
| e | 69538 | 8.2% |
| n | 60164 | 7.1% |
| r | 53992 | 6.3% |
| i | 43499 | 5.1% |
| o | 39828 | 4.7% |
| l | 36502 | 4.3% |
| s | 27912 | 3.3% |
| t | 21626 | 2.5% |
| Other values (52) | 293531 |
| Distinct | 6139 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Minimum | 1916-02-10 00:00:00 |
|---|---|
| Maximum | 1986-06-25 00:00:00 |
DimCustomer.MaritalStatus
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| M | |
|---|---|
| S |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 60398 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| M | 33273 | |
| S | 27125 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 33273 | |
| s | 27125 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 33273 | |
| S | 27125 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 33273 | |
| S | 27125 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 33273 | |
| S | 27125 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 33273 | |
| S | 27125 |
DimCustomer.Gender
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| M | |
|---|---|
| F |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 60398 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | F |
| 5th row | F |
Common Values
| Value | Count | Frequency (%) |
| M | 30381 | |
| F | 30017 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 30381 | |
| f | 30017 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 30381 | |
| F | 30017 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 30381 | |
| F | 30017 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 30381 | |
| F | 30017 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 30381 | |
| F | 30017 |
DimCustomer.YearlyIncome
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59715.057 |
| Minimum | 10000 |
|---|---|
| Maximum | 170000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 10000 |
| Q1 | 30000 |
| median | 60000 |
| Q3 | 80000 |
| 95-th percentile | 130000 |
| Maximum | 170000 |
| Range | 160000 |
| Interquartile range (IQR) | 50000 |
Descriptive statistics
| Standard deviation | 33065.427 |
|---|---|
| Coefficient of variation (CV) | 0.55372009 |
| Kurtosis | 0.53210281 |
| Mean | 59715.057 |
| Median Absolute Deviation (MAD) | 20000 |
| Skewness | 0.78395658 |
| Sum | 3.60667 × 109 |
| Variance | 1.0933225 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 60000 | 9470 | |
| 40000 | 9181 | |
| 70000 | 8267 | |
| 30000 | 6994 | |
| 20000 | 5128 | |
| 80000 | 4848 | |
| 10000 | 3352 | 5.5% |
| 90000 | 3143 | 5.2% |
| 50000 | 1977 | 3.3% |
| 100000 | 1955 | 3.2% |
| Other values (6) | 6083 |
| Value | Count | Frequency (%) |
| 10000 | 3352 | 5.5% |
| 20000 | 5128 | |
| 30000 | 6994 | |
| 40000 | 9181 | |
| 50000 | 1977 | 3.3% |
| 60000 | 9470 | |
| 70000 | 8267 | |
| 80000 | 4848 | |
| 90000 | 3143 | 5.2% |
| 100000 | 1955 | 3.2% |
| Value | Count | Frequency (%) |
| 170000 | 476 | 0.8% |
| 160000 | 359 | 0.6% |
| 150000 | 385 | 0.6% |
| 130000 | 1906 | 3.2% |
| 120000 | 1242 | 2.1% |
| 110000 | 1715 | 2.8% |
| 100000 | 1955 | 3.2% |
| 90000 | 3143 | 5.2% |
| 80000 | 4848 | |
| 70000 | 8267 |
DimCustomer.TotalChildren
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8507401 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 17048 |
| Zeros (%) | 28.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.6210704 |
|---|---|
| Coefficient of variation (CV) | 0.87590387 |
| Kurtosis | -0.97268895 |
| Mean | 1.8507401 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.46305669 |
| Sum | 111781 |
| Variance | 2.6278693 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 17048 | |
| 2 | 12285 | |
| 1 | 11561 | |
| 4 | 7748 | |
| 3 | 7061 | |
| 5 | 4695 | 7.8% |
| Value | Count | Frequency (%) |
| 0 | 17048 | |
| 1 | 11561 | |
| 2 | 12285 | |
| 3 | 7061 | |
| 4 | 7748 | |
| 5 | 4695 | 7.8% |
| Value | Count | Frequency (%) |
| 5 | 4695 | 7.8% |
| 4 | 7748 | |
| 3 | 7061 | |
| 2 | 12285 | |
| 1 | 11561 | |
| 0 | 17048 |
DimCustomer.EnglishEducation
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Bachelors | |
|---|---|
| Partial College | |
| Graduate Degree | |
| High School | |
| Partial High School |
Length
| Max length | 19 |
|---|---|
| Median length | 15 |
| Mean length | 12.825888 |
| Min length | 9 |
Characters and Unicode
| Total characters | 774658 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Graduate Degree |
|---|---|
| 2nd row | High School |
| 3rd row | Bachelors |
| 4th row | Bachelors |
| 5th row | Bachelors |
Common Values
| Value | Count | Frequency (%) |
| Bachelors | 18144 | |
| Partial College | 16623 | |
| Graduate Degree | 10603 | |
| High School | 10320 | |
| Partial High School | 4708 | 7.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| partial | 21331 | |
| bachelors | 18144 | |
| college | 16623 | |
| high | 15028 | |
| school | 15028 | |
| graduate | 10603 | |
| degree | 10603 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 93802 | |
| l | 87749 | |
| a | 82012 | |
| o | 64823 | 8.4% |
| r | 60681 | 7.8% |
| h | 48200 | 6.2% |
| 46962 | 6.1% | |
| g | 42254 | 5.5% |
| i | 36359 | 4.7% |
| c | 33172 | 4.3% |
| Other values (11) | 178644 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 774658 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 93802 | |
| l | 87749 | |
| a | 82012 | |
| o | 64823 | 8.4% |
| r | 60681 | 7.8% |
| h | 48200 | 6.2% |
| 46962 | 6.1% | |
| g | 42254 | 5.5% |
| i | 36359 | 4.7% |
| c | 33172 | 4.3% |
| Other values (11) | 178644 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 774658 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 93802 | |
| l | 87749 | |
| a | 82012 | |
| o | 64823 | 8.4% |
| r | 60681 | 7.8% |
| h | 48200 | 6.2% |
| 46962 | 6.1% | |
| g | 42254 | 5.5% |
| i | 36359 | 4.7% |
| c | 33172 | 4.3% |
| Other values (11) | 178644 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 774658 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 93802 | |
| l | 87749 | |
| a | 82012 | |
| o | 64823 | 8.4% |
| r | 60681 | 7.8% |
| h | 48200 | 6.2% |
| 46962 | 6.1% | |
| g | 42254 | 5.5% |
| i | 36359 | 4.7% |
| c | 33172 | 4.3% |
| Other values (11) | 178644 |
DimCustomer.EnglishOccupation
Categorical
HIGH CORRELATION 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Professional | |
|---|---|
| Skilled Manual | |
| Management | |
| Clerical | |
| Manual |
Length
| Max length | 14 |
|---|---|
| Median length | 12 |
| Mean length | 10.796218 |
| Min length | 6 |
Characters and Unicode
| Total characters | 652070 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Management |
|---|---|
| 2nd row | Professional |
| 3rd row | Skilled Manual |
| 4th row | Professional |
| 5th row | Skilled Manual |
Common Values
| Value | Count | Frequency (%) |
| Professional | 18995 | |
| Skilled Manual | 14261 | |
| Management | 10594 | |
| Clerical | 9624 | |
| Manual | 6924 | 11.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| manual | 21185 | |
| professional | 18995 | |
| skilled | 14261 | |
| management | 10594 | |
| clerical | 9624 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 92177 | |
| l | 87950 | |
| e | 64068 | |
| n | 61368 | |
| i | 42880 | 6.6% |
| o | 37990 | 5.8% |
| s | 37990 | 5.8% |
| M | 31779 | 4.9% |
| r | 28619 | 4.4% |
| u | 21185 | 3.2% |
| Other values (11) | 146064 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 652070 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 92177 | |
| l | 87950 | |
| e | 64068 | |
| n | 61368 | |
| i | 42880 | 6.6% |
| o | 37990 | 5.8% |
| s | 37990 | 5.8% |
| M | 31779 | 4.9% |
| r | 28619 | 4.4% |
| u | 21185 | 3.2% |
| Other values (11) | 146064 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 652070 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 92177 | |
| l | 87950 | |
| e | 64068 | |
| n | 61368 | |
| i | 42880 | 6.6% |
| o | 37990 | 5.8% |
| s | 37990 | 5.8% |
| M | 31779 | 4.9% |
| r | 28619 | 4.4% |
| u | 21185 | 3.2% |
| Other values (11) | 146064 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 652070 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 92177 | |
| l | 87950 | |
| e | 64068 | |
| n | 61368 | |
| i | 42880 | 6.6% |
| o | 37990 | 5.8% |
| s | 37990 | 5.8% |
| M | 31779 | 4.9% |
| r | 28619 | 4.4% |
| u | 21185 | 3.2% |
| Other values (11) | 146064 |
DimCustomer.HouseOwnerFlag
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 60398 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 41699 | |
| 0 | 18699 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 41699 | |
| 0 | 18699 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 41699 | |
| 0 | 18699 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 41699 | |
| 0 | 18699 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 41699 | |
| 0 | 18699 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 41699 | |
| 0 | 18699 |
DimCustomer.NumberCarsOwned
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| 2 | |
|---|---|
| 1 | |
| 0 | |
| 3 | |
| 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 60398 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 20522 | |
| 1 | 15812 | |
| 0 | 14068 | |
| 3 | 5688 | 9.4% |
| 4 | 4308 | 7.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 20522 | |
| 1 | 15812 | |
| 0 | 14068 | |
| 3 | 5688 | 9.4% |
| 4 | 4308 | 7.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 20522 | |
| 1 | 15812 | |
| 0 | 14068 | |
| 3 | 5688 | 9.4% |
| 4 | 4308 | 7.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 20522 | |
| 1 | 15812 | |
| 0 | 14068 | |
| 3 | 5688 | 9.4% |
| 4 | 4308 | 7.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 20522 | |
| 1 | 15812 | |
| 0 | 14068 | |
| 3 | 5688 | 9.4% |
| 4 | 4308 | 7.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 60398 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 20522 | |
| 1 | 15812 | |
| 0 | 14068 | |
| 3 | 5688 | 9.4% |
| 4 | 4308 | 7.1% |
| Distinct | 1124 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Minimum | 2010-12-29 00:00:00 |
|---|---|
| Maximum | 2014-01-28 00:00:00 |
DimCustomer.CommuteDistance
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| 0-1 Miles | |
|---|---|
| 5-10 Miles | |
| 1-2 Miles | |
| 2-5 Miles | |
| 10+ Miles |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 9.1757509 |
| Min length | 9 |
Characters and Unicode
| Total characters | 554197 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1-2 Miles |
|---|---|
| 2nd row | 5-10 Miles |
| 3rd row | 2-5 Miles |
| 4th row | 2-5 Miles |
| 5th row | 2-5 Miles |
Common Values
| Value | Count | Frequency (%) |
| 0-1 Miles | 21307 | |
| 5-10 Miles | 10615 | |
| 1-2 Miles | 10170 | |
| 2-5 Miles | 10084 | |
| 10+ Miles | 8222 | 13.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| miles | 60398 | |
| 0-1 | 21307 | 17.6% |
| 5-10 | 10615 | 8.8% |
| 1-2 | 10170 | 8.4% |
| 2-5 | 10084 | 8.3% |
| 10 | 8222 | 6.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 60398 | ||
| M | 60398 | |
| i | 60398 | |
| l | 60398 | |
| e | 60398 | |
| s | 60398 | |
| - | 52176 | |
| 1 | 50314 | |
| 0 | 40144 | |
| 5 | 20699 | 3.7% |
| Other values (2) | 28476 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 554197 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 60398 | ||
| M | 60398 | |
| i | 60398 | |
| l | 60398 | |
| e | 60398 | |
| s | 60398 | |
| - | 52176 | |
| 1 | 50314 | |
| 0 | 40144 | |
| 5 | 20699 | 3.7% |
| Other values (2) | 28476 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 554197 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 60398 | ||
| M | 60398 | |
| i | 60398 | |
| l | 60398 | |
| e | 60398 | |
| s | 60398 | |
| - | 52176 | |
| 1 | 50314 | |
| 0 | 40144 | |
| 5 | 20699 | 3.7% |
| Other values (2) | 28476 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 554197 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 60398 | ||
| M | 60398 | |
| i | 60398 | |
| l | 60398 | |
| e | 60398 | |
| s | 60398 | |
| - | 52176 | |
| 1 | 50314 | |
| 0 | 40144 | |
| 5 | 20699 | 3.7% |
| Other values (2) | 28476 |
DimProduct.ProductSubcategoryKey
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.351469 |
| Minimum | 1 |
|---|---|
| Maximum | 37 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 28 |
| Q3 | 37 |
| 95-th percentile | 37 |
| Maximum | 37 |
| Range | 36 |
| Interquartile range (IQR) | 34 |
Descriptive statistics
| Standard deviation | 13.556081 |
|---|---|
| Coefficient of variation (CV) | 0.58052369 |
| Kurtosis | -1.074861 |
| Mean | 23.351469 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | -0.68821771 |
| Sum | 1410382 |
| Variance | 183.76732 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 37 | 17332 | |
| 2 | 8068 | |
| 28 | 7981 | |
| 31 | 6440 | 10.7% |
| 1 | 4970 | 8.2% |
| 21 | 3332 | 5.5% |
| 19 | 2190 | 3.6% |
| 3 | 2167 | 3.6% |
| 30 | 2121 | 3.5% |
| 20 | 1430 | 2.4% |
| Other values (7) | 4367 | 7.2% |
| Value | Count | Frequency (%) |
| 1 | 4970 | |
| 2 | 8068 | |
| 3 | 2167 | 3.6% |
| 19 | 2190 | 3.6% |
| 20 | 1430 | 2.4% |
| 21 | 3332 | |
| 22 | 1019 | 1.7% |
| 23 | 568 | 0.9% |
| 25 | 562 | 0.9% |
| 26 | 328 | 0.5% |
| Value | Count | Frequency (%) |
| 37 | 17332 | |
| 32 | 733 | 1.2% |
| 31 | 6440 | 10.7% |
| 30 | 2121 | 3.5% |
| 29 | 908 | 1.5% |
| 28 | 7981 | |
| 27 | 249 | 0.4% |
| 26 | 328 | 0.5% |
| 25 | 562 | 0.9% |
| 23 | 568 | 0.9% |
| Distinct | 130 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
Length
| Max length | 31 |
|---|---|
| Median length | 26 |
| Mean length | 19.308835 |
| Min length | 12 |
Characters and Unicode
| Total characters | 1166215 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Road-650 Black, 62 |
|---|---|
| 2nd row | Road-150 Red, 48 |
| 3rd row | Road-650 Black, 58 |
| 4th row | Road-150 Red, 56 |
| 5th row | Road-650 Red, 52 |
| Value | Count | Frequency (%) |
| tire | 14141 | 7.1% |
| mountain | 11679 | 5.9% |
| 8334 | 4.2% | |
| bottle | 7981 | 4.0% |
| black | 7394 | 3.7% |
| tube | 6959 | 3.5% |
| road | 6916 | 3.5% |
| sport-100 | 6440 | 3.3% |
| helmet | 6440 | 3.3% |
| oz | 4977 | 2.5% |
| Other values (71) | 116660 |
Most occurring characters
| Value | Count | Frequency (%) |
| 137523 | 11.8% | |
| e | 97490 | 8.4% |
| o | 75934 | 6.5% |
| t | 65916 | 5.7% |
| a | 62687 | 5.4% |
| i | 48872 | 4.2% |
| n | 45744 | 3.9% |
| 0 | 44110 | 3.8% |
| l | 44076 | 3.8% |
| r | 43494 | 3.7% |
| Other values (47) | 500369 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1166215 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 137523 | 11.8% | |
| e | 97490 | 8.4% |
| o | 75934 | 6.5% |
| t | 65916 | 5.7% |
| a | 62687 | 5.4% |
| i | 48872 | 4.2% |
| n | 45744 | 3.9% |
| 0 | 44110 | 3.8% |
| l | 44076 | 3.8% |
| r | 43494 | 3.7% |
| Other values (47) | 500369 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1166215 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 137523 | 11.8% | |
| e | 97490 | 8.4% |
| o | 75934 | 6.5% |
| t | 65916 | 5.7% |
| a | 62687 | 5.4% |
| i | 48872 | 4.2% |
| n | 45744 | 3.9% |
| 0 | 44110 | 3.8% |
| l | 44076 | 3.8% |
| r | 43494 | 3.7% |
| Other values (47) | 500369 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1166215 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 137523 | 11.8% | |
| e | 97490 | 8.4% |
| o | 75934 | 6.5% |
| t | 65916 | 5.7% |
| a | 62687 | 5.4% |
| i | 48872 | 4.2% |
| n | 45744 | 3.9% |
| 0 | 44110 | 3.8% |
| l | 44076 | 3.8% |
| r | 43494 | 3.7% |
| Other values (47) | 500369 |
DimProduct.DimProductSubcategory.EnglishProductSubcategoryName
Categorical
HIGH CORRELATION 
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Tires and Tubes | |
|---|---|
| Road Bikes | |
| Bottles and Cages | |
| Helmets | |
| Mountain Bikes | |
| Other values (12) |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 11.767294 |
| Min length | 4 |
Characters and Unicode
| Total characters | 710721 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Road Bikes |
|---|---|
| 2nd row | Road Bikes |
| 3rd row | Road Bikes |
| 4th row | Road Bikes |
| 5th row | Road Bikes |
Common Values
| Value | Count | Frequency (%) |
| Tires and Tubes | 17332 | |
| Road Bikes | 8068 | |
| Bottles and Cages | 7981 | |
| Helmets | 6440 | 10.7% |
| Mountain Bikes | 4970 | 8.2% |
| Jerseys | 3332 | 5.5% |
| Caps | 2190 | 3.6% |
| Touring Bikes | 2167 | 3.6% |
| Fenders | 2121 | 3.5% |
| Gloves | 1430 | 2.4% |
| Other values (7) | 4367 | 7.2% |
Length
| Value | Count | Frequency (%) |
| and | 25313 | |
| tires | 17332 | |
| tubes | 17332 | |
| bikes | 15205 | |
| road | 8068 | 6.3% |
| bottles | 7981 | 6.3% |
| cages | 7981 | 6.3% |
| helmets | 6440 | 5.0% |
| mountain | 4970 | 3.9% |
| jerseys | 3332 | 2.6% |
| Other values (13) | 13585 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 94002 | |
| s | 89605 | |
| 67141 | 9.4% | |
| a | 51473 | 7.2% |
| n | 41431 | 5.8% |
| i | 40984 | 5.8% |
| T | 36831 | 5.2% |
| d | 36484 | 5.1% |
| t | 29935 | 4.2% |
| r | 27612 | 3.9% |
| Other values (23) | 195223 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 710721 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 94002 | |
| s | 89605 | |
| 67141 | 9.4% | |
| a | 51473 | 7.2% |
| n | 41431 | 5.8% |
| i | 40984 | 5.8% |
| T | 36831 | 5.2% |
| d | 36484 | 5.1% |
| t | 29935 | 4.2% |
| r | 27612 | 3.9% |
| Other values (23) | 195223 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 710721 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 94002 | |
| s | 89605 | |
| 67141 | 9.4% | |
| a | 51473 | 7.2% |
| n | 41431 | 5.8% |
| i | 40984 | 5.8% |
| T | 36831 | 5.2% |
| d | 36484 | 5.1% |
| t | 29935 | 4.2% |
| r | 27612 | 3.9% |
| Other values (23) | 195223 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 710721 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 94002 | |
| s | 89605 | |
| 67141 | 9.4% | |
| a | 51473 | 7.2% |
| n | 41431 | 5.8% |
| i | 40984 | 5.8% |
| T | 36831 | 5.2% |
| d | 36484 | 5.1% |
| t | 29935 | 4.2% |
| r | 27612 | 3.9% |
| Other values (23) | 195223 |
DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName
Categorical
HIGH CORRELATION 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Accessories | |
|---|---|
| Bikes | |
| Clothing |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.0374681 |
| Min length | 5 |
Characters and Unicode
| Total characters | 545845 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bikes |
|---|---|
| 2nd row | Bikes |
| 3rd row | Bikes |
| 4th row | Bikes |
| 5th row | Bikes |
Common Values
| Value | Count | Frequency (%) |
| Accessories | 36092 | |
| Bikes | 15205 | |
| Clothing | 9101 | 15.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| accessories | 36092 | |
| bikes | 15205 | |
| clothing | 9101 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 123481 | |
| e | 87389 | |
| c | 72184 | |
| i | 60398 | |
| o | 45193 | 8.3% |
| A | 36092 | 6.6% |
| r | 36092 | 6.6% |
| B | 15205 | 2.8% |
| k | 15205 | 2.8% |
| C | 9101 | 1.7% |
| Other values (5) | 45505 | 8.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 545845 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 123481 | |
| e | 87389 | |
| c | 72184 | |
| i | 60398 | |
| o | 45193 | 8.3% |
| A | 36092 | 6.6% |
| r | 36092 | 6.6% |
| B | 15205 | 2.8% |
| k | 15205 | 2.8% |
| C | 9101 | 1.7% |
| Other values (5) | 45505 | 8.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 545845 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 123481 | |
| e | 87389 | |
| c | 72184 | |
| i | 60398 | |
| o | 45193 | 8.3% |
| A | 36092 | 6.6% |
| r | 36092 | 6.6% |
| B | 15205 | 2.8% |
| k | 15205 | 2.8% |
| C | 9101 | 1.7% |
| Other values (5) | 45505 | 8.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 545845 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 123481 | |
| e | 87389 | |
| c | 72184 | |
| i | 60398 | |
| o | 45193 | 8.3% |
| A | 36092 | 6.6% |
| r | 36092 | 6.6% |
| B | 15205 | 2.8% |
| k | 15205 | 2.8% |
| C | 9101 | 1.7% |
| Other values (5) | 45505 | 8.3% |
DimPromotion.EnglishPromotionName
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| No Discount | |
|---|---|
| Volume Discount 11 to 14 | 2118 |
| Touring-3000 Promotion | 20 |
| Touring-1000 Promotion | 13 |
Length
| Max length | 24 |
|---|---|
| Median length | 11 |
| Mean length | 11.461886 |
| Min length | 11 |
Characters and Unicode
| Total characters | 692275 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Discount |
|---|---|
| 2nd row | No Discount |
| 3rd row | No Discount |
| 4th row | No Discount |
| 5th row | No Discount |
Common Values
| Value | Count | Frequency (%) |
| No Discount | 58247 | |
| Volume Discount 11 to 14 | 2118 | 3.5% |
| Touring-3000 Promotion | 20 | < 0.1% |
| Touring-1000 Promotion | 13 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| discount | 60365 | |
| no | 58247 | |
| volume | 2118 | 1.7% |
| 11 | 2118 | 1.7% |
| to | 2118 | 1.7% |
| 14 | 2118 | 1.7% |
| promotion | 33 | < 0.1% |
| touring-3000 | 20 | < 0.1% |
| touring-1000 | 13 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 122980 | |
| 66752 | ||
| u | 62516 | |
| t | 62516 | |
| i | 60431 | |
| n | 60431 | |
| D | 60365 | |
| s | 60365 | |
| c | 60365 | |
| N | 58247 | |
| Other values (13) | 17307 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 692275 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 122980 | |
| 66752 | ||
| u | 62516 | |
| t | 62516 | |
| i | 60431 | |
| n | 60431 | |
| D | 60365 | |
| s | 60365 | |
| c | 60365 | |
| N | 58247 | |
| Other values (13) | 17307 | 2.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 692275 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 122980 | |
| 66752 | ||
| u | 62516 | |
| t | 62516 | |
| i | 60431 | |
| n | 60431 | |
| D | 60365 | |
| s | 60365 | |
| c | 60365 | |
| N | 58247 | |
| Other values (13) | 17307 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 692275 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 122980 | |
| 66752 | ||
| u | 62516 | |
| t | 62516 | |
| i | 60431 | |
| n | 60431 | |
| D | 60365 | |
| s | 60365 | |
| c | 60365 | |
| N | 58247 | |
| Other values (13) | 17307 | 2.5% |
DimPromotion.EnglishPromotionType
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| No Discount | |
|---|---|
| Volume Discount | 2118 |
| New Product | 33 |
Length
| Max length | 15 |
|---|---|
| Median length | 11 |
| Mean length | 11.14027 |
| Min length | 11 |
Characters and Unicode
| Total characters | 672850 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Discount |
|---|---|
| 2nd row | No Discount |
| 3rd row | No Discount |
| 4th row | No Discount |
| 5th row | No Discount |
Common Values
| Value | Count | Frequency (%) |
| No Discount | 58247 | |
| Volume Discount | 2118 | 3.5% |
| New Product | 33 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| discount | 60365 | |
| no | 58247 | |
| volume | 2118 | 1.8% |
| new | 33 | < 0.1% |
| product | 33 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 120763 | |
| u | 62516 | |
| t | 60398 | |
| 60398 | ||
| c | 60398 | |
| D | 60365 | |
| i | 60365 | |
| s | 60365 | |
| n | 60365 | |
| N | 58280 | |
| Other values (8) | 8637 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 672850 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 120763 | |
| u | 62516 | |
| t | 60398 | |
| 60398 | ||
| c | 60398 | |
| D | 60365 | |
| i | 60365 | |
| s | 60365 | |
| n | 60365 | |
| N | 58280 | |
| Other values (8) | 8637 | 1.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 672850 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 120763 | |
| u | 62516 | |
| t | 60398 | |
| 60398 | ||
| c | 60398 | |
| D | 60365 | |
| i | 60365 | |
| s | 60365 | |
| n | 60365 | |
| N | 58280 | |
| Other values (8) | 8637 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 672850 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 120763 | |
| u | 62516 | |
| t | 60398 | |
| 60398 | ||
| c | 60398 | |
| D | 60365 | |
| i | 60365 | |
| s | 60365 | |
| n | 60365 | |
| N | 58280 | |
| Other values (8) | 8637 | 1.3% |
DimPromotion.EnglishPromotionCategory
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| No Discount | |
|---|---|
| Reseller | 2151 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.893159 |
| Min length | 8 |
Characters and Unicode
| Total characters | 657925 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Discount |
|---|---|
| 2nd row | No Discount |
| 3rd row | No Discount |
| 4th row | No Discount |
| 5th row | No Discount |
Common Values
| Value | Count | Frequency (%) |
| No Discount | 58247 | |
| Reseller | 2151 | 3.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 58247 | |
| discount | 58247 | |
| reseller | 2151 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 116494 | |
| s | 60398 | |
| N | 58247 | |
| 58247 | ||
| D | 58247 | |
| i | 58247 | |
| c | 58247 | |
| u | 58247 | |
| n | 58247 | |
| t | 58247 | |
| Other values (4) | 15057 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 657925 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 116494 | |
| s | 60398 | |
| N | 58247 | |
| 58247 | ||
| D | 58247 | |
| i | 58247 | |
| c | 58247 | |
| u | 58247 | |
| n | 58247 | |
| t | 58247 | |
| Other values (4) | 15057 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 657925 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 116494 | |
| s | 60398 | |
| N | 58247 | |
| 58247 | ||
| D | 58247 | |
| i | 58247 | |
| c | 58247 | |
| u | 58247 | |
| n | 58247 | |
| t | 58247 | |
| Other values (4) | 15057 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 657925 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 116494 | |
| s | 60398 | |
| N | 58247 | |
| 58247 | ||
| D | 58247 | |
| i | 58247 | |
| c | 58247 | |
| u | 58247 | |
| n | 58247 | |
| t | 58247 | |
| Other values (4) | 15057 | 2.3% |
DimSalesTerritory.SalesTerritoryRegion
Categorical
HIGH CORRELATION 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Australia | |
|---|---|
| Southwest | |
| Northwest | |
| Canada | |
| United Kingdom | |
| Other values (5) |
Length
| Max length | 14 |
|---|---|
| Median length | 9 |
| Mean length | 8.7302229 |
| Min length | 6 |
Characters and Unicode
| Total characters | 527288 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Southwest |
|---|---|
| 2nd row | Southwest |
| 3rd row | Southwest |
| 4th row | Southwest |
| 5th row | Southwest |
Common Values
| Value | Count | Frequency (%) |
| Australia | 13345 | |
| Southwest | 12265 | |
| Northwest | 8993 | |
| Canada | 7620 | |
| United Kingdom | 6906 | |
| Germany | 5625 | |
| France | 5558 | |
| Southeast | 39 | 0.1% |
| Northeast | 27 | < 0.1% |
| Central | 20 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| australia | 13345 | |
| southwest | 12265 | |
| northwest | 8993 | |
| canada | 7620 | |
| united | 6906 | |
| kingdom | 6906 | |
| germany | 5625 | |
| france | 5558 | |
| southeast | 39 | 0.1% |
| northeast | 27 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 62919 | 11.9% |
| a | 60819 | 11.5% |
| e | 39433 | 7.5% |
| s | 34669 | 6.6% |
| r | 33568 | 6.4% |
| n | 32635 | 6.2% |
| o | 28230 | 5.4% |
| i | 27157 | 5.2% |
| u | 25649 | 4.9% |
| d | 21432 | 4.1% |
| Other values (16) | 160777 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 527288 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 62919 | 11.9% |
| a | 60819 | 11.5% |
| e | 39433 | 7.5% |
| s | 34669 | 6.6% |
| r | 33568 | 6.4% |
| n | 32635 | 6.2% |
| o | 28230 | 5.4% |
| i | 27157 | 5.2% |
| u | 25649 | 4.9% |
| d | 21432 | 4.1% |
| Other values (16) | 160777 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 527288 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 62919 | 11.9% |
| a | 60819 | 11.5% |
| e | 39433 | 7.5% |
| s | 34669 | 6.6% |
| r | 33568 | 6.4% |
| n | 32635 | 6.2% |
| o | 28230 | 5.4% |
| i | 27157 | 5.2% |
| u | 25649 | 4.9% |
| d | 21432 | 4.1% |
| Other values (16) | 160777 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 527288 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 62919 | 11.9% |
| a | 60819 | 11.5% |
| e | 39433 | 7.5% |
| s | 34669 | 6.6% |
| r | 33568 | 6.4% |
| n | 32635 | 6.2% |
| o | 28230 | 5.4% |
| i | 27157 | 5.2% |
| u | 25649 | 4.9% |
| d | 21432 | 4.1% |
| Other values (16) | 160777 |
DimSalesTerritory.SalesTerritoryCountry
Categorical
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| United States | |
|---|---|
| Australia | |
| Canada | |
| United Kingdom | |
| Germany |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 10.144442 |
| Min length | 6 |
Characters and Unicode
| Total characters | 612704 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United States |
|---|---|
| 2nd row | United States |
| 3rd row | United States |
| 4th row | United States |
| 5th row | United States |
Common Values
| Value | Count | Frequency (%) |
| United States | 21344 | |
| Australia | 13345 | |
| Canada | 7620 | 12.6% |
| United Kingdom | 6906 | 11.4% |
| Germany | 5625 | 9.3% |
| France | 5558 | 9.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 28250 | |
| states | 21344 | |
| australia | 13345 | |
| canada | 7620 | 8.6% |
| kingdom | 6906 | 7.8% |
| germany | 5625 | 6.3% |
| france | 5558 | 6.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 84283 | |
| a | 82077 | |
| e | 60777 | |
| n | 53959 | |
| i | 48501 | 7.9% |
| d | 42776 | 7.0% |
| s | 34689 | 5.7% |
| U | 28250 | 4.6% |
| 28250 | 4.6% | |
| r | 24528 | 4.0% |
| Other values (13) | 124614 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 612704 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 84283 | |
| a | 82077 | |
| e | 60777 | |
| n | 53959 | |
| i | 48501 | 7.9% |
| d | 42776 | 7.0% |
| s | 34689 | 5.7% |
| U | 28250 | 4.6% |
| 28250 | 4.6% | |
| r | 24528 | 4.0% |
| Other values (13) | 124614 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 612704 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 84283 | |
| a | 82077 | |
| e | 60777 | |
| n | 53959 | |
| i | 48501 | 7.9% |
| d | 42776 | 7.0% |
| s | 34689 | 5.7% |
| U | 28250 | 4.6% |
| 28250 | 4.6% | |
| r | 24528 | 4.0% |
| Other values (13) | 124614 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 612704 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 84283 | |
| a | 82077 | |
| e | 60777 | |
| n | 53959 | |
| i | 48501 | 7.9% |
| d | 42776 | 7.0% |
| s | 34689 | 5.7% |
| U | 28250 | 4.6% |
| 28250 | 4.6% | |
| r | 24528 | 4.0% |
| Other values (13) | 124614 |
DimSalesTerritory.SalesTerritoryGroup
Categorical
HIGH CORRELATION 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| North America | |
|---|---|
| Europe | |
| Pacific |
Length
| Max length | 13 |
|---|---|
| Median length | 7 |
| Mean length | 9.5778171 |
| Min length | 6 |
Characters and Unicode
| Total characters | 578481 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | North America |
|---|---|
| 2nd row | North America |
| 3rd row | North America |
| 4th row | North America |
| 5th row | North America |
Common Values
| Value | Count | Frequency (%) |
| North America | 28964 | |
| Europe | 18089 | |
| Pacific | 13345 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| north | 28964 | |
| america | 28964 | |
| europe | 18089 | |
| pacific | 13345 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 76017 | |
| c | 55654 | |
| i | 55654 | |
| e | 47053 | 8.1% |
| o | 47053 | 8.1% |
| a | 42309 | 7.3% |
| m | 28964 | 5.0% |
| N | 28964 | 5.0% |
| A | 28964 | 5.0% |
| 28964 | 5.0% | |
| Other values (7) | 138885 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 578481 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 76017 | |
| c | 55654 | |
| i | 55654 | |
| e | 47053 | 8.1% |
| o | 47053 | 8.1% |
| a | 42309 | 7.3% |
| m | 28964 | 5.0% |
| N | 28964 | 5.0% |
| A | 28964 | 5.0% |
| 28964 | 5.0% | |
| Other values (7) | 138885 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 578481 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 76017 | |
| c | 55654 | |
| i | 55654 | |
| e | 47053 | 8.1% |
| o | 47053 | 8.1% |
| a | 42309 | 7.3% |
| m | 28964 | 5.0% |
| N | 28964 | 5.0% |
| A | 28964 | 5.0% |
| 28964 | 5.0% | |
| Other values (7) | 138885 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 578481 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 76017 | |
| c | 55654 | |
| i | 55654 | |
| e | 47053 | 8.1% |
| o | 47053 | 8.1% |
| a | 42309 | 7.3% |
| m | 28964 | 5.0% |
| N | 28964 | 5.0% |
| A | 28964 | 5.0% |
| 28964 | 5.0% | |
| Other values (7) | 138885 |
Cost
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 337.10483 |
| Minimum | 1.097 |
|---|---|
| Maximum | 2547.0126 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 1.097 |
|---|---|
| 5-th percentile | 1.097 |
| Q1 | 3.8081 |
| median | 14.3653 |
| Q3 | 351.2787 |
| 95-th percentile | 1775.3382 |
| Maximum | 2547.0126 |
| Range | 2545.9156 |
| Interquartile range (IQR) | 347.4706 |
Descriptive statistics
| Standard deviation | 649.77051 |
|---|---|
| Coefficient of variation (CV) | 1.9275028 |
| Kurtosis | 2.6559275 |
| Mean | 337.10483 |
| Median Absolute Deviation (MAD) | 11.975 |
| Skewness | 1.9456942 |
| Sum | 20360457 |
| Variance | 422201.72 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.3903 | 8827 | 14.6% |
| 16.7603 | 6440 | 10.7% |
| 1.097 | 3191 | 5.3% |
| 1.9113 | 2376 | 3.9% |
| 4.3063 | 2280 | 3.8% |
| 7.8663 | 2190 | 3.6% |
| 10.5284 | 2121 | 3.5% |
| 4.7853 | 2025 | 3.4% |
| 11.9703 | 1788 | 3.0% |
| 43.7413 | 1736 | 2.9% |
| Other values (35) | 27424 |
| Value | Count | Frequency (%) |
| 1.097 | 3191 | 5.3% |
| 1.9113 | 2376 | 3.9% |
| 2.3903 | 8827 | |
| 3.8081 | 908 | 1.5% |
| 4.3063 | 2280 | 3.8% |
| 4.7853 | 2025 | 3.4% |
| 7.8663 | 2190 | 3.6% |
| 10.2938 | 1044 | 1.7% |
| 10.5284 | 2121 | 3.5% |
| 11.7308 | 1430 | 2.4% |
| Value | Count | Frequency (%) |
| 2547.0126 | 1551 | |
| 2269.1534 | 185 | 0.3% |
| 2252.4684 | 211 | 0.3% |
| 1811.4997 | 706 | |
| 1775.3382 | 439 | 0.7% |
| 1732.2653 | 1255 | |
| 1549.7479 | 758 | |
| 1509.2185 | 1215 | |
| 1492.9553 | 1262 | |
| 1335.355 | 521 | 0.9% |
Profit
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 148.98208 |
| Minimum | 1.1237 |
|---|---|
| Maximum | 1130.8366 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 1.1237 |
|---|---|
| 5-th percentile | 1.193 |
| Q1 | 2.5997 |
| median | 13.0197 |
| Q3 | 139.6414 |
| 95-th percentile | 810.7715 |
| Maximum | 1130.8366 |
| Range | 1129.7129 |
| Interquartile range (IQR) | 137.0417 |
Descriptive statistics
| Standard deviation | 282.06958 |
|---|---|
| Coefficient of variation (CV) | 1.8933121 |
| Kurtosis | 2.5053805 |
| Mean | 148.98208 |
| Median Absolute Deviation (MAD) | 10.42 |
| Skewness | 1.9515348 |
| Sum | 8998219.8 |
| Variance | 79563.247 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.5997 | 8827 | 14.6% |
| 18.2297 | 6440 | 10.7% |
| 1.193 | 3191 | 5.3% |
| 2.0787 | 2376 | 3.9% |
| 4.6837 | 2280 | 3.8% |
| 1.1237 | 2190 | 3.6% |
| 11.4516 | 2121 | 3.5% |
| 5.2047 | 2025 | 3.4% |
| 13.0197 | 1788 | 3.0% |
| 6.2487 | 1736 | 2.9% |
| Other values (35) | 27424 |
| Value | Count | Frequency (%) |
| 1.1237 | 2190 | 3.6% |
| 1.193 | 3191 | 5.3% |
| 2.0787 | 2376 | 3.9% |
| 2.5997 | 8827 | |
| 4.1419 | 908 | 1.5% |
| 4.6837 | 2280 | 3.8% |
| 5.2047 | 2025 | 3.4% |
| 6.2487 | 1736 | 2.9% |
| 6.7487 | 1596 | 2.6% |
| 11.1962 | 1044 | 1.7% |
| Value | Count | Frequency (%) |
| 1130.8366 | 185 | 0.3% |
| 1122.5216 | 211 | 0.3% |
| 1031.2574 | 1551 | |
| 810.7715 | 1215 | |
| 802.0347 | 1262 | |
| 736.0646 | 521 | 0.9% |
| 728.1328 | 554 | 0.9% |
| 668.0118 | 439 | 0.7% |
| 651.8047 | 1255 | |
| 631.8503 | 706 |
YearlyIncomeRange
Categorical
HIGH CORRELATION 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| $50,000 - $79,999 | |
|---|---|
| $30,000 - $49,999 | |
| $80,000 - $170,000 | |
| $10,000 - $29,999 |
Length
| Max length | 18 |
|---|---|
| Median length | 17 |
| Mean length | 17.26539 |
| Min length | 17 |
Characters and Unicode
| Total characters | 1042795 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | $80,000 - $170,000 |
|---|---|
| 2nd row | $50,000 - $79,999 |
| 3rd row | $50,000 - $79,999 |
| 4th row | $50,000 - $79,999 |
| 5th row | $50,000 - $79,999 |
Common Values
| Value | Count | Frequency (%) |
| $50,000 - $79,999 | 19714 | |
| $30,000 - $49,999 | 16175 | |
| $80,000 - $170,000 | 16029 | |
| $10,000 - $29,999 | 8480 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 60398 | ||
| 50,000 | 19714 | 10.9% |
| 79,999 | 19714 | 10.9% |
| 30,000 | 16175 | 8.9% |
| 49,999 | 16175 | 8.9% |
| 80,000 | 16029 | 8.8% |
| 170,000 | 16029 | 8.8% |
| 10,000 | 8480 | 4.7% |
| 29,999 | 8480 | 4.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 305708 | |
| 9 | 177476 | |
| $ | 120796 | 11.6% |
| , | 120796 | 11.6% |
| 120796 | 11.6% | |
| - | 60398 | 5.8% |
| 7 | 35743 | 3.4% |
| 1 | 24509 | 2.4% |
| 5 | 19714 | 1.9% |
| 3 | 16175 | 1.6% |
| Other values (3) | 40684 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1042795 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 305708 | |
| 9 | 177476 | |
| $ | 120796 | 11.6% |
| , | 120796 | 11.6% |
| 120796 | 11.6% | |
| - | 60398 | 5.8% |
| 7 | 35743 | 3.4% |
| 1 | 24509 | 2.4% |
| 5 | 19714 | 1.9% |
| 3 | 16175 | 1.6% |
| Other values (3) | 40684 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1042795 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 305708 | |
| 9 | 177476 | |
| $ | 120796 | 11.6% |
| , | 120796 | 11.6% |
| 120796 | 11.6% | |
| - | 60398 | 5.8% |
| 7 | 35743 | 3.4% |
| 1 | 24509 | 2.4% |
| 5 | 19714 | 1.9% |
| 3 | 16175 | 1.6% |
| Other values (3) | 40684 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1042795 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 305708 | |
| 9 | 177476 | |
| $ | 120796 | 11.6% |
| , | 120796 | 11.6% |
| 120796 | 11.6% | |
| - | 60398 | 5.8% |
| 7 | 35743 | 3.4% |
| 1 | 24509 | 2.4% |
| 5 | 19714 | 1.9% |
| 3 | 16175 | 1.6% |
| Other values (3) | 40684 | 3.9% |
Age
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 71 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.38435 |
| Minimum | 37 |
|---|---|
| Maximum | 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 472.0 KiB |
Quantile statistics
| Minimum | 37 |
|---|---|
| 5-th percentile | 39 |
| Q1 | 45 |
| median | 52 |
| Q3 | 62 |
| 95-th percentile | 76 |
| Maximum | 108 |
| Range | 71 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 11.334976 |
|---|---|
| Coefficient of variation (CV) | 0.20842348 |
| Kurtosis | -0.027375664 |
| Mean | 54.38435 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.70210222 |
| Sum | 3284706 |
| Variance | 128.48167 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 49 | 2319 | 3.8% |
| 42 | 2271 | 3.8% |
| 48 | 2268 | 3.8% |
| 44 | 2230 | 3.7% |
| 50 | 2216 | 3.7% |
| 52 | 2213 | 3.7% |
| 45 | 2181 | 3.6% |
| 51 | 2151 | 3.6% |
| 43 | 2139 | 3.5% |
| 47 | 2091 | 3.5% |
| Other values (61) | 38319 |
| Value | Count | Frequency (%) |
| 37 | 241 | 0.4% |
| 38 | 1230 | |
| 39 | 1636 | |
| 40 | 1909 | |
| 41 | 1762 | |
| 42 | 2271 | |
| 43 | 2139 | |
| 44 | 2230 | |
| 45 | 2181 | |
| 46 | 1968 |
| Value | Count | Frequency (%) |
| 108 | 3 | < 0.1% |
| 107 | 2 | < 0.1% |
| 106 | 10 | |
| 105 | 9 | |
| 103 | 2 | < 0.1% |
| 102 | 2 | < 0.1% |
| 101 | 4 | < 0.1% |
| 100 | 8 | |
| 99 | 11 | |
| 98 | 8 |
Age Range
Categorical
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 472.0 KiB |
| Over 45 | |
|---|---|
| 31-45 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.4834597 |
| Min length | 5 |
Characters and Unicode
| Total characters | 391588 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Over 45 |
|---|---|
| 2nd row | 31-45 |
| 3rd row | Over 45 |
| 4th row | Over 45 |
| 5th row | Over 45 |
Common Values
| Value | Count | Frequency (%) |
| Over 45 | 44799 | |
| 31-45 | 15599 | 25.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| over | 44799 | |
| 45 | 44799 | |
| 31-45 | 15599 | 14.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 60398 | |
| 5 | 60398 | |
| O | 44799 | |
| v | 44799 | |
| e | 44799 | |
| r | 44799 | |
| 44799 | ||
| 3 | 15599 | 4.0% |
| 1 | 15599 | 4.0% |
| - | 15599 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 391588 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 60398 | |
| 5 | 60398 | |
| O | 44799 | |
| v | 44799 | |
| e | 44799 | |
| r | 44799 | |
| 44799 | ||
| 3 | 15599 | 4.0% |
| 1 | 15599 | 4.0% |
| - | 15599 | 4.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 391588 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 60398 | |
| 5 | 60398 | |
| O | 44799 | |
| v | 44799 | |
| e | 44799 | |
| r | 44799 | |
| 44799 | ||
| 3 | 15599 | 4.0% |
| 1 | 15599 | 4.0% |
| - | 15599 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 391588 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 60398 | |
| 5 | 60398 | |
| O | 44799 | |
| v | 44799 | |
| e | 44799 | |
| r | 44799 | |
| 44799 | ||
| 3 | 15599 | 4.0% |
| 1 | 15599 | 4.0% |
| - | 15599 | 4.0% |
| Age | Age Range | Cost | CurrencyKey | CustomerKey | DimCurrency.CurrencyName | DimCustomer.CommuteDistance | DimCustomer.EnglishEducation | DimCustomer.EnglishOccupation | DimCustomer.Gender | DimCustomer.HouseOwnerFlag | DimCustomer.MaritalStatus | DimCustomer.NumberCarsOwned | DimCustomer.TotalChildren | DimCustomer.YearlyIncome | DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName | DimProduct.DimProductSubcategory.EnglishProductSubcategoryName | DimProduct.ProductSubcategoryKey | DimPromotion.EnglishPromotionCategory | DimPromotion.EnglishPromotionName | DimPromotion.EnglishPromotionType | DimSalesTerritory.SalesTerritoryCountry | DimSalesTerritory.SalesTerritoryGroup | DimSalesTerritory.SalesTerritoryRegion | ExtendedAmount | Freight | ProductKey | ProductStandardCost | Profit | PromotionKey | SalesAmount | SalesOrderLineNumber | SalesTerritoryKey | TaxAmt | TotalProductCost | UnitPrice | YearlyIncomeRange | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Age | 1.000 | 0.916 | -0.033 | 0.068 | -0.028 | 0.045 | 0.192 | 0.205 | 0.242 | 0.027 | 0.128 | 0.196 | 0.193 | 0.549 | 0.184 | 0.055 | 0.031 | 0.028 | 0.007 | 0.000 | 0.003 | 0.059 | 0.082 | 0.046 | -0.032 | -0.032 | -0.012 | -0.033 | -0.028 | 0.000 | -0.032 | 0.011 | -0.072 | -0.032 | -0.033 | -0.032 | 0.148 |
| Age Range | 0.916 | 1.000 | 0.003 | 0.046 | -0.015 | 0.049 | 0.067 | 0.103 | 0.242 | 0.000 | 0.120 | 0.163 | 0.069 | 0.452 | 0.212 | 0.003 | 0.025 | -0.006 | 0.000 | 0.004 | 0.000 | 0.049 | 0.045 | 0.050 | 0.003 | 0.003 | -0.016 | 0.003 | 0.004 | 0.004 | 0.003 | 0.011 | -0.036 | 0.003 | 0.003 | 0.003 | 0.223 |
| Cost | -0.033 | 0.003 | 1.000 | -0.054 | -0.027 | 0.125 | 0.044 | 0.039 | 0.062 | 0.005 | 0.025 | 0.044 | 0.064 | -0.052 | 0.041 | 0.707 | 0.480 | -0.714 | 0.187 | 0.133 | 0.150 | 0.079 | 0.112 | 0.059 | 0.998 | 0.998 | -0.173 | 1.000 | 0.932 | 0.133 | 0.998 | -0.386 | 0.058 | 0.998 | 1.000 | 0.998 | 0.091 |
| CurrencyKey | 0.068 | 0.046 | -0.054 | 1.000 | 0.096 | 1.000 | 0.134 | 0.101 | 0.117 | 0.011 | 0.051 | 0.045 | 0.108 | 0.077 | -0.100 | 0.117 | 0.094 | 0.049 | 0.010 | 0.006 | 0.009 | 0.690 | 0.735 | 0.690 | -0.053 | -0.053 | 0.014 | -0.054 | -0.050 | 0.006 | -0.053 | 0.037 | -0.651 | -0.053 | -0.054 | -0.053 | 0.148 |
| CustomerKey | -0.028 | -0.015 | -0.027 | 0.096 | 1.000 | 0.092 | 0.052 | 0.051 | 0.077 | 0.023 | 0.131 | 0.093 | 0.044 | -0.025 | -0.087 | 0.064 | 0.123 | 0.016 | 0.027 | 0.026 | 0.030 | 0.103 | 0.098 | 0.078 | -0.029 | -0.029 | 0.068 | -0.027 | -0.035 | 0.026 | -0.029 | -0.009 | -0.037 | -0.029 | -0.027 | -0.029 | 0.094 |
| DimCurrency.CurrencyName | 0.045 | 0.049 | 0.125 | 1.000 | 0.092 | 1.000 | 0.168 | 0.104 | 0.165 | 0.013 | 0.053 | 0.045 | 0.134 | 0.046 | -0.183 | 0.118 | 0.088 | 0.032 | 0.014 | 0.008 | 0.011 | 0.756 | 0.806 | 0.756 | -0.045 | -0.045 | 0.008 | -0.044 | -0.045 | 0.008 | -0.045 | 0.041 | -0.137 | -0.045 | -0.044 | -0.045 | 0.204 |
| DimCustomer.CommuteDistance | 0.192 | 0.067 | 0.044 | 0.134 | 0.052 | 0.168 | 1.000 | 0.167 | 0.249 | 0.018 | 0.240 | 0.062 | 0.292 | 0.071 | 0.220 | 0.040 | 0.039 | 0.033 | 0.000 | 0.001 | 0.000 | 0.204 | 0.282 | 0.205 | -0.023 | -0.023 | 0.000 | -0.024 | -0.017 | 0.001 | -0.023 | -0.009 | -0.164 | -0.023 | -0.024 | -0.023 | 0.225 |
| DimCustomer.EnglishEducation | 0.205 | 0.103 | 0.039 | 0.101 | 0.051 | 0.104 | 0.167 | 1.000 | 0.265 | 0.014 | 0.142 | 0.097 | 0.312 | -0.006 | -0.206 | 0.047 | 0.040 | 0.056 | 0.000 | 0.000 | 0.000 | 0.135 | 0.176 | 0.139 | -0.056 | -0.056 | 0.018 | -0.057 | -0.050 | 0.000 | -0.056 | 0.005 | -0.025 | -0.056 | -0.057 | -0.056 | 0.256 |
| DimCustomer.EnglishOccupation | 0.242 | 0.242 | 0.062 | 0.117 | 0.077 | 0.165 | 0.249 | 0.265 | 1.000 | 0.024 | 0.132 | 0.175 | 0.231 | -0.034 | 0.159 | 0.025 | 0.046 | 0.011 | 0.007 | 0.005 | 0.005 | 0.293 | 0.411 | 0.296 | -0.005 | -0.005 | 0.003 | -0.006 | -0.003 | 0.005 | -0.005 | -0.008 | -0.225 | -0.005 | -0.006 | -0.005 | 0.641 |
| DimCustomer.Gender | 0.027 | 0.000 | 0.005 | 0.011 | 0.023 | 0.013 | 0.018 | 0.014 | 0.024 | 1.000 | 0.016 | 0.051 | 0.021 | 0.002 | -0.005 | 0.008 | 0.002 | 0.008 | 0.000 | 0.000 | 0.000 | 0.012 | 0.000 | 0.018 | -0.009 | -0.009 | 0.004 | -0.009 | -0.009 | 0.000 | -0.009 | -0.000 | 0.001 | -0.009 | -0.009 | -0.009 | 0.018 |
| DimCustomer.HouseOwnerFlag | 0.128 | 0.120 | 0.025 | 0.051 | 0.131 | 0.053 | 0.240 | 0.142 | 0.132 | 0.016 | 1.000 | 0.311 | 0.160 | 0.199 | 0.058 | 0.000 | 0.029 | -0.007 | 0.000 | 0.000 | 0.000 | 0.054 | 0.054 | 0.058 | 0.008 | 0.008 | -0.014 | 0.008 | 0.010 | 0.000 | 0.008 | 0.005 | -0.044 | 0.008 | 0.008 | 0.008 | 0.082 |
| DimCustomer.MaritalStatus | 0.196 | 0.163 | 0.044 | 0.045 | 0.093 | 0.045 | 0.062 | 0.097 | 0.175 | 0.051 | 0.311 | 1.000 | 0.126 | -0.174 | -0.106 | 0.042 | 0.046 | -0.037 | 0.002 | 0.005 | 0.002 | 0.065 | 0.052 | 0.067 | 0.033 | 0.033 | -0.003 | 0.035 | 0.029 | 0.005 | 0.033 | -0.004 | 0.025 | 0.033 | 0.035 | 0.033 | 0.116 |
| DimCustomer.NumberCarsOwned | 0.193 | 0.069 | 0.064 | 0.108 | 0.044 | 0.134 | 0.292 | 0.312 | 0.231 | 0.021 | 0.160 | 0.126 | 1.000 | 0.250 | 0.398 | 0.063 | 0.055 | 0.075 | 0.000 | 0.004 | 0.007 | 0.157 | 0.209 | 0.159 | -0.059 | -0.059 | -0.001 | -0.061 | -0.051 | 0.004 | -0.059 | -0.003 | -0.001 | -0.059 | -0.061 | -0.059 | 0.312 |
| DimCustomer.TotalChildren | 0.549 | 0.452 | -0.052 | 0.077 | -0.025 | 0.046 | 0.071 | -0.006 | -0.034 | 0.002 | 0.199 | -0.174 | 0.250 | 1.000 | 0.241 | 0.066 | 0.048 | 0.055 | 0.000 | 0.005 | 0.002 | 0.108 | 0.146 | 0.111 | -0.051 | -0.051 | -0.003 | -0.052 | -0.047 | 0.005 | -0.051 | 0.014 | -0.108 | -0.051 | -0.052 | -0.051 | 0.175 |
| DimCustomer.YearlyIncome | 0.184 | 0.212 | 0.041 | -0.100 | -0.087 | -0.183 | 0.220 | -0.206 | 0.159 | -0.005 | 0.058 | -0.106 | 0.398 | 0.241 | 1.000 | 0.025 | 0.035 | -0.034 | 0.011 | 0.006 | 0.008 | 0.302 | 0.430 | 0.230 | 0.043 | 0.043 | -0.051 | 0.041 | 0.046 | 0.006 | 0.043 | 0.013 | -0.123 | 0.043 | 0.041 | 0.043 | 1.000 |
| DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName | 0.055 | 0.003 | 0.707 | 0.117 | 0.064 | 0.118 | 0.040 | 0.047 | 0.025 | 0.008 | 0.000 | 0.042 | 0.063 | 0.066 | 0.025 | 1.000 | 1.000 | -0.783 | 0.114 | 0.082 | 0.083 | 0.103 | 0.088 | 0.104 | 0.585 | 0.585 | -0.208 | 0.605 | 0.378 | 0.082 | 0.585 | -0.182 | 0.042 | 0.585 | 0.605 | 0.585 | 0.019 |
| DimProduct.DimProductSubcategory.EnglishProductSubcategoryName | 0.031 | 0.025 | 0.480 | 0.094 | 0.123 | 0.088 | 0.039 | 0.040 | 0.046 | 0.002 | 0.029 | 0.046 | 0.055 | 0.048 | 0.035 | 1.000 | 1.000 | 0.326 | 0.190 | 0.130 | 0.160 | 0.084 | 0.119 | 0.063 | 0.065 | 0.065 | 0.540 | 0.061 | 0.122 | 0.130 | 0.065 | -0.330 | 0.013 | 0.065 | 0.061 | 0.065 | 0.052 |
| DimProduct.ProductSubcategoryKey | 0.028 | -0.006 | -0.714 | 0.049 | 0.016 | 0.032 | 0.033 | 0.056 | 0.011 | 0.008 | -0.007 | -0.037 | 0.075 | 0.055 | -0.034 | -0.783 | 0.326 | 1.000 | 0.154 | 0.090 | 0.111 | 0.071 | 0.096 | 0.066 | -0.706 | -0.706 | 0.310 | -0.714 | -0.589 | 0.090 | -0.706 | 0.295 | -0.062 | -0.706 | -0.714 | -0.706 | 0.032 |
| DimPromotion.EnglishPromotionCategory | 0.007 | 0.000 | 0.187 | 0.010 | 0.027 | 0.014 | 0.000 | 0.000 | 0.007 | 0.000 | 0.000 | 0.002 | 0.000 | 0.000 | 0.011 | 0.114 | 0.190 | 0.154 | 1.000 | 1.000 | 1.000 | 0.006 | 0.008 | 0.004 | 0.003 | 0.003 | -0.026 | 0.002 | 0.012 | 1.000 | 0.003 | -0.020 | 0.010 | 0.003 | 0.002 | 0.003 | 0.007 |
| DimPromotion.EnglishPromotionName | 0.000 | 0.004 | 0.133 | 0.006 | 0.026 | 0.008 | 0.001 | 0.000 | 0.005 | 0.000 | 0.000 | 0.005 | 0.004 | 0.005 | 0.006 | 0.082 | 0.130 | 0.090 | 1.000 | 1.000 | 1.000 | 0.007 | 0.008 | 0.001 | 0.003 | 0.003 | -0.026 | 0.002 | 0.012 | 1.000 | 0.003 | -0.019 | 0.010 | 0.003 | 0.002 | 0.003 | 0.005 |
| DimPromotion.EnglishPromotionType | 0.003 | 0.000 | 0.150 | 0.009 | 0.030 | 0.011 | 0.000 | 0.000 | 0.005 | 0.000 | 0.000 | 0.002 | 0.007 | 0.002 | 0.008 | 0.083 | 0.160 | 0.111 | 1.000 | 1.000 | 1.000 | 0.009 | 0.008 | 0.006 | -0.004 | -0.004 | -0.035 | -0.005 | 0.006 | 1.000 | -0.004 | -0.014 | 0.011 | -0.004 | -0.005 | -0.004 | 0.004 |
| DimSalesTerritory.SalesTerritoryCountry | 0.059 | 0.049 | 0.079 | 0.690 | 0.103 | 0.756 | 0.204 | 0.135 | 0.293 | 0.012 | 0.054 | 0.065 | 0.157 | 0.108 | 0.302 | 0.103 | 0.084 | 0.071 | 0.006 | 0.007 | 0.009 | 1.000 | 1.000 | 1.000 | -0.038 | -0.038 | 0.007 | -0.040 | -0.033 | 0.007 | -0.038 | 0.032 | -0.681 | -0.038 | -0.040 | -0.038 | 0.329 |
| DimSalesTerritory.SalesTerritoryGroup | 0.082 | 0.045 | 0.112 | 0.735 | 0.098 | 0.806 | 0.282 | 0.176 | 0.411 | 0.000 | 0.054 | 0.052 | 0.209 | 0.146 | 0.430 | 0.088 | 0.119 | 0.096 | 0.008 | 0.008 | 0.008 | 1.000 | 1.000 | 1.000 | 0.049 | 0.049 | -0.007 | 0.048 | 0.051 | 0.008 | 0.049 | -0.040 | -0.048 | 0.049 | 0.048 | 0.049 | 0.400 |
| DimSalesTerritory.SalesTerritoryRegion | 0.046 | 0.050 | 0.059 | 0.690 | 0.078 | 0.756 | 0.205 | 0.139 | 0.296 | 0.018 | 0.058 | 0.067 | 0.159 | 0.111 | 0.230 | 0.104 | 0.063 | 0.066 | 0.004 | 0.001 | 0.006 | 1.000 | 1.000 | 1.000 | -0.032 | -0.032 | 0.005 | -0.033 | -0.030 | 0.001 | -0.032 | 0.036 | -0.254 | -0.032 | -0.033 | -0.032 | 0.330 |
| ExtendedAmount | -0.032 | 0.003 | 0.998 | -0.053 | -0.029 | -0.045 | -0.023 | -0.056 | -0.005 | -0.009 | 0.008 | 0.033 | -0.059 | -0.051 | 0.043 | 0.585 | 0.065 | -0.706 | 0.003 | 0.003 | -0.004 | -0.038 | 0.049 | -0.032 | 1.000 | 1.000 | -0.163 | 0.998 | 0.948 | 0.118 | 1.000 | -0.393 | 0.054 | 1.000 | 0.998 | 1.000 | 0.090 |
| Freight | -0.032 | 0.003 | 0.998 | -0.053 | -0.029 | -0.045 | -0.023 | -0.056 | -0.005 | -0.009 | 0.008 | 0.033 | -0.059 | -0.051 | 0.043 | 0.585 | 0.065 | -0.706 | 0.003 | 0.003 | -0.004 | -0.038 | 0.049 | -0.032 | 1.000 | 1.000 | -0.163 | 0.998 | 0.948 | 0.118 | 1.000 | -0.393 | 0.054 | 1.000 | 0.998 | 1.000 | 0.090 |
| ProductKey | -0.012 | -0.016 | -0.173 | 0.014 | 0.068 | 0.008 | 0.000 | 0.018 | 0.003 | 0.004 | -0.014 | -0.003 | -0.001 | -0.003 | -0.051 | -0.208 | 0.540 | 0.310 | -0.026 | -0.026 | -0.035 | 0.007 | -0.007 | 0.005 | -0.163 | -0.163 | 1.000 | -0.173 | -0.101 | 0.132 | -0.163 | -0.255 | -0.012 | -0.163 | -0.173 | -0.163 | 0.061 |
| ProductStandardCost | -0.033 | 0.003 | 1.000 | -0.054 | -0.027 | -0.044 | -0.024 | -0.057 | -0.006 | -0.009 | 0.008 | 0.035 | -0.061 | -0.052 | 0.041 | 0.605 | 0.061 | -0.714 | 0.002 | 0.002 | -0.005 | -0.040 | 0.048 | -0.033 | 0.998 | 0.998 | -0.173 | 1.000 | 0.932 | 0.133 | 0.998 | -0.386 | 0.058 | 0.998 | 1.000 | 0.998 | 0.091 |
| Profit | -0.028 | 0.004 | 0.932 | -0.050 | -0.035 | -0.045 | -0.017 | -0.050 | -0.003 | -0.009 | 0.010 | 0.029 | -0.051 | -0.047 | 0.046 | 0.378 | 0.122 | -0.589 | 0.012 | 0.012 | 0.006 | -0.033 | 0.051 | -0.030 | 0.948 | 0.948 | -0.101 | 0.932 | 1.000 | 0.122 | 0.948 | -0.433 | 0.044 | 0.948 | 0.932 | 0.948 | 0.090 |
| PromotionKey | 0.000 | 0.004 | 0.133 | 0.006 | 0.026 | 0.008 | 0.001 | 0.000 | 0.005 | 0.000 | 0.000 | 0.005 | 0.004 | 0.005 | 0.006 | 0.082 | 0.130 | 0.090 | 1.000 | 1.000 | 1.000 | 0.007 | 0.008 | 0.001 | 0.118 | 0.118 | 0.132 | 0.133 | 0.122 | 1.000 | 0.003 | -0.020 | 0.010 | 0.003 | 0.002 | 0.003 | 0.005 |
| SalesAmount | -0.032 | 0.003 | 0.998 | -0.053 | -0.029 | -0.045 | -0.023 | -0.056 | -0.005 | -0.009 | 0.008 | 0.033 | -0.059 | -0.051 | 0.043 | 0.585 | 0.065 | -0.706 | 0.003 | 0.003 | -0.004 | -0.038 | 0.049 | -0.032 | 1.000 | 1.000 | -0.163 | 0.998 | 0.948 | 0.003 | 1.000 | -0.393 | 0.054 | 1.000 | 0.998 | 1.000 | 0.090 |
| SalesOrderLineNumber | 0.011 | 0.011 | -0.386 | 0.037 | -0.009 | 0.041 | -0.009 | 0.005 | -0.008 | -0.000 | 0.005 | -0.004 | -0.003 | 0.014 | 0.013 | -0.182 | -0.330 | 0.295 | -0.020 | -0.019 | -0.014 | 0.032 | -0.040 | 0.036 | -0.393 | -0.393 | -0.255 | -0.386 | -0.433 | -0.020 | -0.393 | 1.000 | -0.014 | -0.393 | -0.386 | -0.393 | 0.012 |
| SalesTerritoryKey | -0.072 | -0.036 | 0.058 | -0.651 | -0.037 | -0.137 | -0.164 | -0.025 | -0.225 | 0.001 | -0.044 | 0.025 | -0.001 | -0.108 | -0.123 | 0.042 | 0.013 | -0.062 | 0.010 | 0.010 | 0.011 | -0.681 | -0.048 | -0.254 | 0.054 | 0.054 | -0.012 | 0.058 | 0.044 | 0.010 | 0.054 | -0.014 | 1.000 | 0.054 | 0.058 | 0.054 | 0.330 |
| TaxAmt | -0.032 | 0.003 | 0.998 | -0.053 | -0.029 | -0.045 | -0.023 | -0.056 | -0.005 | -0.009 | 0.008 | 0.033 | -0.059 | -0.051 | 0.043 | 0.585 | 0.065 | -0.706 | 0.003 | 0.003 | -0.004 | -0.038 | 0.049 | -0.032 | 1.000 | 1.000 | -0.163 | 0.998 | 0.948 | 0.003 | 1.000 | -0.393 | 0.054 | 1.000 | 0.998 | 1.000 | 0.090 |
| TotalProductCost | -0.033 | 0.003 | 1.000 | -0.054 | -0.027 | -0.044 | -0.024 | -0.057 | -0.006 | -0.009 | 0.008 | 0.035 | -0.061 | -0.052 | 0.041 | 0.605 | 0.061 | -0.714 | 0.002 | 0.002 | -0.005 | -0.040 | 0.048 | -0.033 | 0.998 | 0.998 | -0.173 | 1.000 | 0.932 | 0.002 | 0.998 | -0.386 | 0.058 | 0.998 | 1.000 | 0.998 | 0.091 |
| UnitPrice | -0.032 | 0.003 | 0.998 | -0.053 | -0.029 | -0.045 | -0.023 | -0.056 | -0.005 | -0.009 | 0.008 | 0.033 | -0.059 | -0.051 | 0.043 | 0.585 | 0.065 | -0.706 | 0.003 | 0.003 | -0.004 | -0.038 | 0.049 | -0.032 | 1.000 | 1.000 | -0.163 | 0.998 | 0.948 | 0.003 | 1.000 | -0.393 | 0.054 | 1.000 | 0.998 | 1.000 | 0.090 |
| YearlyIncomeRange | 0.148 | 0.223 | 0.091 | 0.148 | 0.094 | 0.204 | 0.225 | 0.256 | 0.641 | 0.018 | 0.082 | 0.116 | 0.312 | 0.175 | 1.000 | 0.019 | 0.052 | 0.032 | 0.007 | 0.005 | 0.004 | 0.329 | 0.400 | 0.330 | 0.090 | 0.090 | 0.061 | 0.091 | 0.090 | 0.005 | 0.090 | 0.012 | 0.330 | 0.090 | 0.091 | 0.090 | 1.000 |
| ProductKey | CustomerKey | PromotionKey | CurrencyKey | SalesTerritoryKey | SalesOrderNumber | SalesOrderLineNumber | RevisionNumber | OrderQuantity | UnitPrice | ExtendedAmount | ProductStandardCost | TotalProductCost | SalesAmount | TaxAmt | Freight | OrderDate | DueDate | ShipDate | DimCurrency.CurrencyName | CustomerFullName | DimCustomer.BirthDate | DimCustomer.MaritalStatus | DimCustomer.Gender | DimCustomer.YearlyIncome | DimCustomer.TotalChildren | DimCustomer.EnglishEducation | DimCustomer.EnglishOccupation | DimCustomer.HouseOwnerFlag | DimCustomer.NumberCarsOwned | DimCustomer.DateFirstPurchase | DimCustomer.CommuteDistance | DimProduct.ProductSubcategoryKey | DimProduct.EnglishProductName | DimProduct.DimProductSubcategory.EnglishProductSubcategoryName | DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName | DimPromotion.EnglishPromotionName | DimPromotion.EnglishPromotionType | DimPromotion.EnglishPromotionCategory | DimSalesTerritory.SalesTerritoryRegion | DimSalesTerritory.SalesTerritoryCountry | DimSalesTerritory.SalesTerritoryGroup | Cost | Profit | YearlyIncomeRange | Age | Age Range | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 336 | 14501 | 1 | 100 | 4 | SO43700 | 1 | 1 | 1 | 699.0982 | 699.0982 | 413.1463 | 413.1463 | 699.0982 | 55.9279 | 17.4775 | 2010-12-29 | 2011-01-10 | 2011-01-05 | US Dollar | Lucas Hill | 1943-11-10 | M | M | 80000 | 4 | Graduate Degree | Management | 1 | 2 | 2010-12-29 | 1-2 Miles | 2 | Road-650 Black, 62 | Road Bikes | Bikes | No Discount | No Discount | No Discount | Southwest | United States | North America | 486.5517 | 212.5465 | $80,000 - $170,000 | 80 | Over 45 |
| 1 | 312 | 27612 | 1 | 100 | 4 | SO43719 | 1 | 1 | 1 | 3578.2700 | 3578.2700 | 2171.2942 | 2171.2942 | 3578.2700 | 286.2616 | 89.4568 | 2011-01-03 | 2011-01-15 | 2011-01-10 | US Dollar | Kelvin Huang | 1978-11-18 | M | M | 60000 | 2 | High School | Professional | 1 | 2 | 2011-01-03 | 5-10 Miles | 2 | Road-150 Red, 48 | Road Bikes | Bikes | No Discount | No Discount | No Discount | Southwest | United States | North America | 2547.0126 | 1031.2574 | $50,000 - $79,999 | 45 | 31-45 |
| 2 | 332 | 14560 | 1 | 100 | 4 | SO43726 | 1 | 1 | 1 | 699.0982 | 699.0982 | 413.1463 | 413.1463 | 699.0982 | 55.9279 | 17.4775 | 2011-01-05 | 2011-01-17 | 2011-01-12 | US Dollar | Courtney Carter | 1976-03-31 | M | M | 50000 | 1 | Bachelors | Skilled Manual | 1 | 1 | 2011-01-05 | 2-5 Miles | 2 | Road-650 Black, 58 | Road Bikes | Bikes | No Discount | No Discount | No Discount | Southwest | United States | North America | 486.5517 | 212.5465 | $50,000 - $79,999 | 48 | Over 45 |
| 3 | 314 | 27578 | 1 | 100 | 4 | SO43762 | 1 | 1 | 1 | 3578.2700 | 3578.2700 | 2171.2942 | 2171.2942 | 3578.2700 | 286.2616 | 89.4568 | 2011-01-14 | 2011-01-26 | 2011-01-21 | US Dollar | Ashley Washington | 1964-05-07 | M | F | 60000 | 1 | Bachelors | Professional | 1 | 1 | 2011-01-14 | 2-5 Miles | 2 | Road-150 Red, 56 | Road Bikes | Bikes | No Discount | No Discount | No Discount | Southwest | United States | North America | 2547.0126 | 1031.2574 | $50,000 - $79,999 | 59 | Over 45 |
| 4 | 330 | 14559 | 1 | 100 | 4 | SO43771 | 1 | 1 | 1 | 699.0982 | 699.0982 | 413.1463 | 413.1463 | 699.0982 | 55.9279 | 17.4775 | 2011-01-16 | 2011-01-28 | 2011-01-23 | US Dollar | Jeremy Murphy | 1976-03-20 | M | F | 50000 | 1 | Bachelors | Skilled Manual | 1 | 0 | 2011-01-16 | 2-5 Miles | 2 | Road-650 Red, 52 | Road Bikes | Bikes | No Discount | No Discount | No Discount | Southwest | United States | North America | 486.5517 | 212.5465 | $50,000 - $79,999 | 48 | Over 45 |
| 5 | 312 | 27651 | 1 | 100 | 4 | SO43820 | 1 | 1 | 1 | 3578.2700 | 3578.2700 | 2171.2942 | 2171.2942 | 3578.2700 | 286.2616 | 89.4568 | 2011-01-25 | 2011-02-06 | 2011-02-01 | US Dollar | Philip Gomez | 1961-05-05 | M | M | 90000 | 2 | High School | Professional | 1 | 1 | 2011-01-25 | 10+ Miles | 2 | Road-150 Red, 48 | Road Bikes | Bikes | No Discount | No Discount | No Discount | Southwest | United States | North America | 2547.0126 | 1031.2574 | $80,000 - $170,000 | 62 | Over 45 |
| 6 | 312 | 28038 | 1 | 100 | 4 | SO43930 | 1 | 1 | 1 | 3578.2700 | 3578.2700 | 2171.2942 | 2171.2942 | 3578.2700 | 286.2616 | 89.4568 | 2011-02-01 | 2011-02-13 | 2011-02-08 | US Dollar | Melanie Foster | 1953-08-19 | M | M | 70000 | 2 | Partial College | Professional | 1 | 2 | 2011-02-01 | 10+ Miles | 2 | Road-150 Red, 48 | Road Bikes | Bikes | No Discount | No Discount | No Discount | Southwest | United States | North America | 2547.0126 | 1031.2574 | $50,000 - $79,999 | 70 | Over 45 |
| 7 | 336 | 14572 | 1 | 100 | 4 | SO44002 | 1 | 1 | 1 | 699.0982 | 699.0982 | 413.1463 | 413.1463 | 699.0982 | 55.9279 | 17.4775 | 2011-02-16 | 2011-02-28 | 2011-02-23 | US Dollar | Charles Moore | 1976-10-13 | M | F | 70000 | 3 | Graduate Degree | Professional | 1 | 0 | 2011-02-16 | 2-5 Miles | 2 | Road-650 Black, 62 | Road Bikes | Bikes | No Discount | No Discount | No Discount | Southwest | United States | North America | 486.5517 | 212.5465 | $50,000 - $79,999 | 47 | Over 45 |
| 8 | 310 | 28172 | 1 | 100 | 4 | SO44148 | 1 | 1 | 1 | 3578.2700 | 3578.2700 | 2171.2942 | 2171.2942 | 3578.2700 | 286.2616 | 89.4568 | 2011-03-03 | 2011-03-15 | 2011-03-10 | US Dollar | Jacqueline Ward | 1972-11-23 | M | M | 60000 | 1 | Partial College | Skilled Manual | 1 | 1 | 2011-03-03 | 2-5 Miles | 2 | Road-150 Red, 62 | Road Bikes | Bikes | No Discount | No Discount | No Discount | Southwest | United States | North America | 2547.0126 | 1031.2574 | $50,000 - $79,999 | 51 | Over 45 |
| 9 | 312 | 28168 | 1 | 100 | 4 | SO44153 | 1 | 1 | 1 | 3578.2700 | 3578.2700 | 2171.2942 | 2171.2942 | 3578.2700 | 286.2616 | 89.4568 | 2011-03-04 | 2011-03-16 | 2011-03-11 | US Dollar | Fernando Turner | 1967-04-09 | M | F | 60000 | 1 | Partial College | Skilled Manual | 1 | 1 | 2011-03-04 | 2-5 Miles | 2 | Road-150 Red, 48 | Road Bikes | Bikes | No Discount | No Discount | No Discount | Southwest | United States | North America | 2547.0126 | 1031.2574 | $50,000 - $79,999 | 56 | Over 45 |
| ProductKey | CustomerKey | PromotionKey | CurrencyKey | SalesTerritoryKey | SalesOrderNumber | SalesOrderLineNumber | RevisionNumber | OrderQuantity | UnitPrice | ExtendedAmount | ProductStandardCost | TotalProductCost | SalesAmount | TaxAmt | Freight | OrderDate | DueDate | ShipDate | DimCurrency.CurrencyName | CustomerFullName | DimCustomer.BirthDate | DimCustomer.MaritalStatus | DimCustomer.Gender | DimCustomer.YearlyIncome | DimCustomer.TotalChildren | DimCustomer.EnglishEducation | DimCustomer.EnglishOccupation | DimCustomer.HouseOwnerFlag | DimCustomer.NumberCarsOwned | DimCustomer.DateFirstPurchase | DimCustomer.CommuteDistance | DimProduct.ProductSubcategoryKey | DimProduct.EnglishProductName | DimProduct.DimProductSubcategory.EnglishProductSubcategoryName | DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName | DimPromotion.EnglishPromotionName | DimPromotion.EnglishPromotionType | DimPromotion.EnglishPromotionCategory | DimSalesTerritory.SalesTerritoryRegion | DimSalesTerritory.SalesTerritoryCountry | DimSalesTerritory.SalesTerritoryGroup | Cost | Profit | YearlyIncomeRange | Age | Age Range | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60388 | 530 | 14974 | 1 | 98 | 10 | SO73609 | 2 | 1 | 1 | 4.99 | 4.99 | 1.8663 | 1.8663 | 4.99 | 0.3992 | 0.1248 | 2013-12-21 | 2014-01-02 | 2013-12-28 | United Kingdom Pound | K. Saravan | 1984-12-29 | S | M | 30000 | 3 | Partial College | Clerical | 1 | 2 | 2013-03-31 | 0-1 Miles | 37 | Touring Tire Tube | Tires and Tubes | Accessories | No Discount | No Discount | No Discount | United Kingdom | United Kingdom | Europe | 2.3903 | 2.5997 | $30,000 - $49,999 | 39 | 31-45 |
| 60389 | 217 | 14974 | 1 | 98 | 10 | SO73609 | 3 | 1 | 1 | 34.99 | 34.99 | 13.0863 | 13.0863 | 34.99 | 2.7992 | 0.8748 | 2013-12-21 | 2014-01-02 | 2013-12-28 | United Kingdom Pound | K. Saravan | 1984-12-29 | S | M | 30000 | 3 | Partial College | Clerical | 1 | 2 | 2013-03-31 | 0-1 Miles | 31 | Sport-100 Helmet, Black | Helmets | Accessories | No Discount | No Discount | No Discount | United Kingdom | United Kingdom | Europe | 16.7603 | 18.2297 | $30,000 - $49,999 | 39 | 31-45 |
| 60390 | 231 | 14974 | 1 | 98 | 10 | SO73609 | 4 | 1 | 1 | 49.99 | 49.99 | 38.4923 | 38.4923 | 49.99 | 3.9992 | 1.2498 | 2013-12-21 | 2014-01-02 | 2013-12-28 | United Kingdom Pound | Jim Rodman | 1984-12-29 | S | M | 30000 | 3 | Partial College | Clerical | 1 | 2 | 2013-03-31 | 0-1 Miles | 21 | Long-Sleeve Logo Jersey, M | Jerseys | Clothing | No Discount | No Discount | No Discount | United Kingdom | United Kingdom | Europe | 43.7413 | 6.2487 | $30,000 - $49,999 | 39 | 31-45 |
| 60391 | 361 | 20562 | 1 | 98 | 10 | SO73662 | 1 | 1 | 1 | 2294.99 | 2294.99 | 1251.9813 | 1251.9813 | 2294.99 | 183.5992 | 57.3748 | 2013-12-22 | 2014-01-03 | 2013-12-29 | United Kingdom Pound | Andy Ruth | 1966-09-09 | M | F | 130000 | 3 | Partial College | Professional | 1 | 3 | 2011-08-14 | 5-10 Miles | 1 | Mountain-200 Black, 42 | Mountain Bikes | Bikes | No Discount | No Discount | No Discount | United Kingdom | United Kingdom | Europe | 1492.9553 | 802.0347 | $80,000 - $170,000 | 57 | Over 45 |
| 60392 | 529 | 22706 | 1 | 100 | 8 | SO74748 | 1 | 1 | 1 | 3.99 | 3.99 | 1.4923 | 1.4923 | 3.99 | 0.3192 | 0.0998 | 2014-01-16 | 2014-01-28 | 2014-01-23 | US Dollar | Andy Ruth | 1981-10-24 | S | F | 30000 | 0 | Partial College | Clerical | 1 | 1 | 2014-01-16 | 2-5 Miles | 37 | Road Tire Tube | Tires and Tubes | Accessories | No Discount | No Discount | No Discount | Germany | Germany | Europe | 1.9113 | 2.0787 | $30,000 - $49,999 | 42 | 31-45 |
| 60393 | 225 | 22706 | 1 | 100 | 8 | SO74748 | 2 | 1 | 1 | 8.99 | 8.99 | 6.9223 | 6.9223 | 8.99 | 0.7192 | 0.2248 | 2014-01-16 | 2014-01-28 | 2014-01-23 | US Dollar | Andy Ruth | 1981-10-24 | S | F | 30000 | 0 | Partial College | Clerical | 1 | 1 | 2014-01-16 | 2-5 Miles | 19 | AWC Logo Cap | Caps | Clothing | No Discount | No Discount | No Discount | Germany | Germany | Europe | 7.8663 | 1.1237 | $30,000 - $49,999 | 42 | 31-45 |
| 60394 | 491 | 22706 | 1 | 100 | 8 | SO74748 | 3 | 1 | 1 | 53.99 | 53.99 | 41.5723 | 41.5723 | 53.99 | 4.3192 | 1.3498 | 2014-01-16 | 2014-01-28 | 2014-01-23 | US Dollar | Timothy Sneath | 1981-10-24 | S | F | 30000 | 0 | Partial College | Clerical | 1 | 1 | 2014-01-16 | 2-5 Miles | 21 | Short-Sleeve Classic Jersey, XL | Jerseys | Clothing | No Discount | No Discount | No Discount | Germany | Germany | Europe | 47.2413 | 6.7487 | $30,000 - $49,999 | 42 | 31-45 |
| 60395 | 535 | 17708 | 1 | 100 | 10 | SO74828 | 1 | 1 | 1 | 24.99 | 24.99 | 9.3463 | 9.3463 | 24.99 | 1.9992 | 0.6248 | 2014-01-19 | 2014-01-31 | 2014-01-26 | US Dollar | Timothy Sneath | 1966-12-15 | M | M | 20000 | 1 | Graduate Degree | Clerical | 1 | 0 | 2013-11-13 | 0-1 Miles | 37 | LL Mountain Tire | Tires and Tubes | Accessories | No Discount | No Discount | No Discount | United Kingdom | United Kingdom | Europe | 11.9703 | 13.0197 | $10,000 - $29,999 | 57 | Over 45 |
| 60396 | 477 | 17708 | 1 | 100 | 10 | SO74828 | 2 | 1 | 1 | 4.99 | 4.99 | 1.8663 | 1.8663 | 4.99 | 0.3992 | 0.1248 | 2014-01-19 | 2014-01-31 | 2014-01-26 | US Dollar | Timothy Sneath | 1966-12-15 | M | M | 20000 | 1 | Graduate Degree | Clerical | 1 | 0 | 2013-11-13 | 0-1 Miles | 28 | Water Bottle - 30 oz. | Bottles and Cages | Accessories | No Discount | No Discount | No Discount | United Kingdom | United Kingdom | Europe | 2.3903 | 2.5997 | $10,000 - $29,999 | 57 | Over 45 |
| 60397 | 471 | 17708 | 1 | 100 | 10 | SO74828 | 3 | 1 | 1 | 63.50 | 63.50 | 23.7490 | 23.7490 | 63.50 | 5.0800 | 1.5875 | 2014-01-19 | 2014-01-31 | 2014-01-26 | US Dollar | NaN | 1966-12-15 | M | M | 20000 | 1 | Graduate Degree | Clerical | 1 | 0 | 2013-11-13 | 0-1 Miles | 25 | Classic Vest, S | Vests | Clothing | No Discount | No Discount | No Discount | United Kingdom | United Kingdom | Europe | 30.4165 | 33.0835 | $10,000 - $29,999 | 57 | Over 45 |